如何加快从sq的数据检索；服务器到asp.net [英] How to speed up data retrieval from sq; server to asp.net

问题描述

大家好
请给我建议.
实际上，我正在使用存储过程从sql server数据库中检索数据.
并将其与asp.net中的列表框绑定.
从sql server检索数据我正在使用简单的
在存储过程中选择语句.
但是现在的问题是表中大约有200万记录.
因此数据检索速度非常慢.所以请帮忙.
在此先感谢

Hi all
please suggest me.
actually i am retrieving data from sql server database by using store procedure.
and bind it with listbox in asp.net.
for retrieving data from sql server i am using the simple
select statement in store procedure.
but now problem is that there ate approximately 20 lakhs records in table .
so the data is retrieving very slowly. so please help.
Thanks in advance

推荐答案

首先，表是否已正确索引?
其次，不要带回所有记录-只带回少量记录，让用户决定是否需要查看更多记录或过滤后的记录子集.

First, is the table correctly indexed?
Second, don''t bring back all of the records - only bring back a small amount and let the user decide if they need to see more or a filtered subset of records.

这篇关于如何加快从sq的数据检索；服务器到asp.net的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！