Speeding up server side

Newinthezone

Hi all

I am using datatables server side processing on my MVC application. IT works well but when I have records up to the tune of 1 to 2 million , the server takes way to long to load before it can send the first 10 records to the client. It takes to long for the object on the server to load data from the database after which it proceeds to send data back to the client. It takes 8 minutes for 2 million records to be loaded onto the server in my case.
Is there any way through which server side could be optimized to load data faster. If this is not related to datatables, could you please suggest any other methods through which data could be loaded faster. Something like caching techniques through which data is loaded again and again for different clients. Well thats just my idea but hoping to look for a better solution.

Thanks

allan

I'm afraid that this is outside the realms of what I think you will be able to find help for in these forums - certainly it is beyond my ability to help I'm afraid. All I can say is that there must be a more efficient way to query the db than a method that takes 8 minutes - but I have no idea what that would be in .NET! SO might be a place to go for this kind of question.

Allan