Very poor and slow loading of large records from database

Thanks every one for your reply. I have solved the problem.actually the problem was in my LINQ query which was retrieving SELECT * instead of SELECT TOP(10) statement internally so all 6 millions records are selected at once :)

when i remove tolist() method and use skip() and take() for custom paging in single LINQ IQueryable var type my application become fast.Now it can load more than 6 millions records very fast.

tolist() method load all records and does not use SELECT TOP(10).

I advice you don't use tolist() in single statement of your LINQ query. Use skip and take. You can use tolist() when you pass query to your Model. Always use IQueryable generic type because it is used for databases. If you need paging for large records use custom paging such as take() and skip() function. They translate into top(10) SQL query and your application performs very fast