Trading application performance problem

Question

Hello all

We are coding a trading application and almost near to complete. Our problem is its performance, when we use it for trial purpose, its very slow and don't update data in real time when we try to sort and filter the data. Is it possible to get sharp and quick response, when data is change or update. I can't provide you code.

We are looking for all related solutions.

kible hana · Answer

hello Jitendra gives you right solution. As use of indexers and stored procedures can make it well. If you are testing it means you are going to complete it. I will prefer you to go for some custom components do develop your application specially for performance based. Which will help you to increase performance while real time data updating sorting filtering and grouping. Here is one dapfor.com .net grid which can also help you.

Jiteendra Sampathirao · Answer

Hi 1. use indexers 2. use stored procedures... 3. implement partitioning... 4. Sql server tuning...etc.... refer Link Link2