对于ASP.NET自动完成超快速的数据搜索，请引导我 [英] ASP.NET super fast data search for autocomplete, please guide me

问题描述

感谢您的时间和精力。

我有ajaxtookit自动完成和requriment是让超级快。目前的数据是在数据库和每一个请求是牵强，来自数据库。这个数据是联系人和地址，并常新记录将在表中添加。有3个解决方案，浮现在脑海中。请指导我，你有什么建议，什么你觉得是最好的。

I have ajaxtookit Autocomplete and requriment is to make it super fast. Currently data is in database and on every request it is fetched and come from database. This data are contacts and addresses and often new records will be added in the tables. There are 3 solutions that come to mind. Please guide me what you suggest and what you feel is the best.

1. 让数据库中的数据，只是做索引和可能的话做一些连接轮询使连接建立时间可以保存。

1. Let the data in database, just do indexing and if possible do some connection polling so that connection establishing time can be saved.

在应用服务器缓存数据。使用LINQ查询。

Cache data in application server. Use Linq to query.

不要对某些文件排序的数据进行搜索。

Do search on sorted data in some file.

请引导和帮助我。

感谢

推荐答案

如果您的数据不经常改变，我会用的服务器端缓存。

If your data doesn't change very often, I'd go with server-side caching.

这篇关于对于ASP.NET自动完成超快速的数据搜索，请引导我的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！