如何在客户端存储大型DataSet [英] How to store large DataSet at Client Side

问题描述

我有一个应用程序，其中我显示数千（25-40万）中的一些结果。在一个页面上，我显示125条记录。在这里，我需要在客户端存储数据集，以便在下一页上他可以看到下一个记录，而不会在DataBase上点击。



我用ViewSate，Cache和会话对象，但这些都不是成功的。



1.由于更多往返，Viewstate需要时间，但它在Localhost上运行良好。

2.缓存无效。搜索结果与onw和其他用户发生冲突。

2.会话无效。搜索结果与onw和其他用户发生冲突。

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.

推荐答案

我认为任何经过验证的解决方案，但我会对您有所了解：



1.将所有数据存储到Browswer Cache并使用任何第三方javascript api访问数据

3.将所有数据存储在Cache中并通过Ajax调用获取数据

4.在Sql Server端使用Paging并进行正常处理

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

这篇关于如何在客户端存储大型DataSet的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！