November 15, 2007 at 8:14 pm
I'm trying setting up a site similar to eshop. There may be 1 million items in sqlserver2005. In order to search some products, user may input some words to search product name,description with or without logical operator, or may input bar code for bar code search.
How should such function be implemented? Should I use conditional select with 'where' 'like' ? OR should I use tools something like lucene ?
Is there any friend has such experience? is there any muture codes such as store procedure ?
Thank you!
November 16, 2007 at 6:45 am
I am not an expert at this but i think if your using seperate textbox's for differnet types of input , e.g one for Bar code, another for product name then i think u can use stored procedures (provided the underlying tables are highly normalised and have indexes) . Or another thing i think can help is full text indexing. but again I am not an expert.
November 16, 2007 at 7:40 am
You're going to probably want to look at Full-Text searches against the name and description fields (you'll have to set that up and schedule the updates). That will speed up your searches against those fields.
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply