I'm not sure if this is the appropriate forum to ask this question; however, here goes.
I'm being asked to create/modify a search engine for our Web site. Beyond trying to enhance the speed, I've been asked to add spelling and punctuation checks into the search text.
Right now, all that's being done is a simple like statement.
What's the best method to query a database?
For example, if someone typed in "A and W" or "A/Ws" to get the value"A & W's", how would I make the link? Is there a database table that exists that I could reference to replace & with and (or vice versa) , etc... Is there a good place to start?
I suggest that you look into using the SQL Server full text indexing.
|||Delayed response (I'm finally getting back to this issue).
So I've tried to create a stored procedure that does both a ContainsTable search and a FreeTextTable search. This seems like it's going to be a pig of a procedure. (Plus I get duplicate records that I need to filter out). The results are pretty good, but I'm worried about performance. Anyone have any experience in using these options? Any good best practices I should be looking out for?
No comments:
Post a Comment