Having strong demand to develop fast paging in my ASP.NET application I tried to cache my tables for display. And I was quite surprised when occurred that my LINQ to memory application made paging 8 times slower than LINQ to SQL.
For checking that I developed 2 ASP.NET applications. Both work with tables of having 500 000 records 3 fields each record (the memory structure is identical to SQL table). The controls used are regular:...
Anotherone
Last Activity: May 18 '10, 12:54 PM
Joined: Feb 18 '10
Location:
-
Linq to sql works faster than linq to memory
-
Comparing 2 linq applications: Unexpected result
I developed 2 ASP.NET applications using LINQ. One connects to MS SQL Server, another to some proprietary memory structure.
Both applications work with tables of 3 fields, having 500 000 records (the memory structure is identical to SQL Server table). The controls used are regular: GridView and ObjectDataSourc e.
In the applications I calculate the average time needed for each paging click processing.
LINQ... -
Sorry, then just remove my post. -
Try FastSQLDataSour ce. It helps when you need faster display of large amounts of MS SQL Server data in your web application using grids, lists and other bound controls.
It supports automatic paging and sorting and performs very quickly on large amounts of data
It can work almost without coding or sometimes with no coding at all.Leave a comment:
No activity results to display
Leave a comment: