Click here to Skip to main content
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 19: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 6,803
1 Sergey Alexandrovich Kryukov 6,377
2 DamithSL 5,421
3 Manas Bhardwaj 4,841
4 Maciej Los 4,330


Advertise | Privacy | Mobile
Web02 | 2.8.1411023.1 | Last Updated 13 Jul 2013
Copyright © CodeProject, 1999-2014
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