Click here to Skip to main content
15,886,639 members
Please Sign up or sign in to vote.
3.00/5 (1 vote)
See more: , +
Hi I'm Using Entity Framework In My Application, I Want Fetch The Data As Fast As Possible, What To Do, Which Is Better Dictionary or List or Iqueryable or Ienumerable
Posted
Updated 16-Dec-14 19:19pm
v2
Comments
Member 11286130 17-Dec-14 5:21am    
Hi Raul Iloc i'm asking which among is best to load data more fast

1 solution

1.The speed of any application does not depend on the used list/dictionary class.

2.To improve the speed of any application that use large set of data, the most important aspect is to use pagination. I have an article about this subject in the context of an ASP.NET application, and I provide there the pagination at the database level by providing a SP that could be adapted and extended. Advanced ASPX GridView Pagination and Data Entities[^]

3. In the context of web application other important aspect is to use AJAX and to avoid to postback the entire page (including the data set stored in the page view state). There a lot of article about this subject including my next article: MVC Basic Site: Step 4 – jqGrid Integration in MVC 4.0 using AJAX, JSON, jQuery, LINQ, and Serialization[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900