Basically, I"m not searching the contents of my website but rather records in a product table. And I want the users to be able to put
something generic as half a movie title or product name.
And so, I want to know if either there's a way to optimize searching tables with the LIKE clause etc. or if it just really comes down to using teh Index Server.
But if there are other implementations or methods out there would someone please let me know? Thanks.
Index Server (now Indexing Services) doesn't search databases, it searches your files/folders. Queries search databases. You'll want full text indexing installed on the database, and you'll want to make sure your indexes are optimized. There are third party tools that can help as well. Filtering out noise words and using NEAR is one technique to make some of the responses closer to the intended result.
Jeff
|||I should add that Indexing Services do come into play when you configure full text searching, it's not really exclusive to file systems it's just that you have to specifically configure the database not Indexing Services as such. SQL keeps the indexes in Indexing Services. There is a lot of information on the web about this, depending on the verion of SQL you use. Migght look at:
http://www.databasejournal.com/features/mssql/article.php/1438211
http://www.developer.com/db/article.php/3446891
http://www.eggheadcafe.com/articles/20010422.asp
And yes, it's probably the best way to handle this.
Jeff
No comments:
Post a Comment