469,081 Members | 1,413 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

how to implement product search in DB with millions item within eshop ?

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 and 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!
Nov 16 '07 #1
0 959

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Acer | last post: by
1 post views Thread by heath | last post: by
1 post views Thread by Sagaert Johan | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.