Click here to Skip to main content
11,718,016 members (84,347 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET
I have an application where i display the results in some of the thousands (25-40 thousands). On one page i display 125 records. here i need to store the dataset at client side so that on next pages he can see next records without any hit on DataBase.

I tried it with ViewSate,Cache and Session Object but none of these are successfull.

1. Viewstate is taking time due to more roundtrips, but its working well on Localhost.
2. Cache is not working. Search Results are conflicting with onw and another users.
2. Session is not working. Search Results are conflicting with onw and another users.
Posted 12-Jul-13 18:26pm
Comments
Mahesh Bailwal at 13-Jul-13 1:24am
   
I believe you should cache this much amount of data in memory as it may have adverse impact on your performance and its not scalable. You should better go for retrieving Page data from SQL Server. Please check below links

http://www.codeproject.com/Articles/18148/SQL-Server-2005-Paging-Results
http://blog.sqlauthority.com/2013/04/14/sql-server-tricks-for-row-offset-and-paging-in-various-versions-of-sql-server/

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

I think so any authenticated solution but I will have some idea which you follow:

1. Store all data into Browswer Cache and use any third party javascript api to access the data
3. Store all data in Cache and fetch data through Ajax call
4. Use Paging on Sql Server side and go with normal process
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 215
1 F-ES Sitecore 210
2 Maciej Los 140
3 Jochen Arndt 120
4 Andy Lanng 115
0 Sergey Alexandrovich Kryukov 1,649
1 OriginalGriff 535
2 Maciej Los 529
3 Richard MacCutchan 440
4 CHill60 415


Advertise | Privacy | Mobile
Web03 | 2.8.150901.1 | Last Updated 13 Jul 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100