如何使用AutoCompleteExtender更快地获取记录? [英] how to get records faster using AutoCompleteExtender ?

问题描述

AutoCompleteExtender花费太多时间[大约10秒]从sql获取记录
即使查询并不复杂
有什么其他选择可以使其快速实现

非常感谢..

AutoCompleteExtender taking too much time[around 10secs] to get a records from sql
even though query is not complex by any means
is der any alternative to get it fast

many thanks..

推荐答案

下面是关于" AutoCompleteExtender性能"主题的一些讨论.

http://forums.asp.net/t/1225836.aspx

http://stackoverflow.com/questions/6379254/ajax-autocomplete-performance-issues-hit-the-db-or-filter-the-pre-cahced-resu

Below are some discussions on the topic of "AutoCompleteExtender Performance".

http://forums.asp.net/t/1225836.aspx

http://stackoverflow.com/questions/6379254/ajax-autocomplete-performance-issues-to-hit-the-db-or-filter-the-pre-cahced-resu

如果检索简单查询记录，则将完成间隔"值设置为较小.

Set the Completion interval value as less If you retrieve the simple query records.

<asp:AutoCompleteExtender ID="AutoCompleteExtender5" runat="server" CompletionInterval="100"CompletionSetCount="12" EnableCaching="true" MinimumPrefixLength="1" ServiceMethod="GetCompletionList"                                                   ServicePath="~/AutoComplete.asmx" TargetControlID="text_cityfrom">
</asp:AutoCompleteExtender>

这篇关于如何使用AutoCompleteExtender更快地获取记录?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！