如何在asp.net中快速进行搜索结果 [英] How to make search reasults fast in asp.net

问题描述

我的3个表中有很多记录，并且当我单击搜索按钮时，我的表单中有10个搜索条件，然后从很多记录中的3个表中获取数据并将其放入gridview，但是为此， 10-15分钟左右的时间过多.

I have lots of records in my my 3 tables, and I have 10 searching criteria in my form when I click on search button then data fetch from 3 tables from lots of records and put it into gridview, but for this it take too much time around 10-15 minutes. So can any body help me to minimize searching time?

推荐答案

搜索取决于许多因素，例如您在表上拥有哪些索引，有多少个联接正在执行，甚至可能是数据库服务器上的IO性能.

检查索引，对表进行非规范化，使用视图.从这里开始.

The searching is dependent on a number of factors, like what indexes you have on the tables, how many joins are being performed, it could even be IO performance on the database server.

Check the indexes, de-normalize the tables, use views. Start there.

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