查找关键字的最快方法。任何语言，任何系统-Fastestwaytolookupkeywords.Anylanguage,anysystem

I'm quite happy with the Xapian search engine library. Although it sounds like it might be overkill for your scenario, maybe you just want to chuck your data into a big hashtable, like perhaps memcached?

我对Xapian搜索引擎库感到非常满意。虽然听起来对你的场景来说可能有些过分,但也许你只想将你的数据放入一个大的哈希表中,就像memcached一样?

you can try free text on mssql. http://msdn.microsoft.com/en-us/library/ms177652.aspx

你可以尝试在mssql上的自由文本。 http://msdn.microsoft.com/en-us/library/ms177652.aspx

Example query:

SELECT TOP 10 * FROM searchtable 
INNER JOIN FREETEXTTABLE(searchtable, [SEARCH_TEXT], 'query string') AS KEY_TBL
ON searchtable.SEARCH_ID = KEY_TBL.[KEY] 
ORDER BY KEY_TBL.RANK DESC

Josh

A Lucene index might work. Ive used it for pretty big datasets before. It's developed in java but there is also a .NET version.

Lucene索引可能有效。我以前用它来制作相当大的数据集。它是用java开发的,但也有一个.NET版本。

Have you tried fulltext search in MySQL ? Because if you tried it with LIKE comparison, I see why it was slow :).

你在MySQL中尝试过全文搜索吗?因为如果你尝试使用LIKE比较,我明白为什么它很慢:)。

That workload and search pattern is trivial for PostgreSQL with its integrated full text search functionality (integrated as of 8.4 which is now in RC status. It's a contrib module prior to that.)

PostgreSQL具有集成的全文搜索功能(从8.4开始集成,现在处于RC状态。这是之前的一个贡献模块。)工作负载和搜索模式是微不足道的。