如何在asp.net中快速加载数据 [英] how to make data load fast in asp.net

问题描述

全部好，



我从数据库生成一个表格，我的选择查询得到大约10k的记录。现在在C＃端我正在使用表对象并根据数据中的某些条件生成每一行。一切正常，但在浏览器上渲染数据的速度非常慢，每次我都有请求超时错误。由于一些明显的原因，我无法使用网格，转发器或任何类型的jQuery网格。有人可以请告诉我如何提高速度或如何打破数据，以便加快速度。





我的表是单页类的东西，没有分页，排序或搜索。所以不能应用rownumber逻辑只加载等于pagesize或其他东西的数据。

HI all,

i am generating a table from a database where my select query get around 10k of records. now on C# side i am using table object and generate each rows based on some condition from the data. everything works fine but the speed of rendering the data is very slow on the browser and everytime i got request time out error. i can't use grid , repeater or any kind of jQuery grid due to some obvious reasons. can someone please tell me how can i improve the speed or how can i break the data so it loads faster.


my table is a single page kind of thing there is no paging , sorting or searching. so can not apply the rownumber logic to load only data equal to pagesize or something.

推荐答案

嗨Ravi，



有几种方法可以提高应用程序的速度和性能。更改数据库端或服务器端代码。



例如在数据库级别。

您可以创建视图和索引



服务器端

您可以使用AJAX，Repeater在用户请求下一条记录时首次显示有限记录然后执行ajax调用以仅获取那些记录来自服务器端的记录。

Hi Ravi,

There is several way to increase speed and performance of your application. Changing on Database side or Server side code.

for example at Database level.
You can create view and indexing

for server side
You can use AJAX, Repeater to show limited records at first time when user make request for next records then do ajax call to get only those records from the server side.

这篇关于如何在asp.net中快速加载数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！