如何使数据获取更快，我认为这是一项具有挑战性的任务 [英] How to make Data Fetching Faster,i thout it is challenging task

问题描述

我必须通过传递Empid来获取单个表格中 1,00,000 记录的记录数据，我该怎么做，



您能否建议最好的最快的方式数据转换方式



我的想法是： - 在DataCache中存储数据集

- ajax用jquery调用webmethods







提前谢谢。

I have to fetch data record by record from 1,00,000 of records in a single form by passing Empid , How should i do,

Could u suggest The best fastest way of data retriving way

my thought is: - Storing Dataset in DataCache
- ajax calls to webmethods with jquery



Thank you in advance .

推荐答案

1. use Repeater for binding Data instead of Grid
2. Create a view 

没有用户会在页面上查看这些记录。

所以，你可以做的是，只需要获取你想要在页面上显示的记录数。

同时实现自定义分页，这意味着您将设计一个 SQL过程，它将输入作为页码和您需要的记录数量并相应地返回。



你可以请参阅一个示例 - ASP中的自定义分页.Net GridView使用SQL Server存储过程 [ ^ ]。



如你所说的那样，你可以实现 jQuery Ajax 获取数据并绑定到 GridView 。

您也可以使用 jQGrids 。

No user would look at these much of records on a page.
So, what you can do is, just fetch the number of records you want to show on a page.
Also implement Custom Paging, that means you will design one SQL Procedure which will take input as Page Number and the Number of Records you need and return you accordingly.

You can see one Example - Custom Paging in ASP.Net GridView using SQL Server Stored Procedure[^].

And yes as you said, you can implement jQuery Ajax to get the Data and bind to GridView.
You can also use jQGrids.

参考



http://www.aspsnippets.com/Articles/Load -on-demand-data-in-GridView-on-scroll-using-ASPNet-and-jQuery-AJAX.aspx [ ^ ]

这篇关于如何使数据获取更快，我认为这是一项具有挑战性的任务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！