开发者

Full text search

开发者 https://www.devze.com 2023-03-10 11:27 出处：网络

Fiends, i am creating a search engine for my own city about service providers in the city. So there can b开发者_运维问答e search for particular keyword or service. Finding data using LIKE will affect

相关专题：.net database full-text-search oracle11g search-engine

Fiends, i am creating a search engine for my own city about service providers in the city. So there can b开发者_运维问答e search for particular keyword or service. Finding data using LIKE will affect my website performance and it is also not a good way. I am using Oracle 11G with .Net and i have heard about Full text search . Is that a efficient way or is there any other way? In my data base there is approximate 100,000 rows. if anyone gives answer for sql server 2008 than it is also acceptable.

Please suggest me some optimized way

My personal opinion is that Lucene.NET is the way to go. It has somewhat of a steep learning curve, but does its job exceptionally well.

StackOverflow search is powered by Lucene.NET.

Oracle Text is the built-in full text search option for Oracle.