By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,962 Members | 1,955 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,962 IT Pros & Developers. It's quick & easy.

Website Search Functionality For 2 Million Products

P: 1
I have an Ecommerce/Online Shopping site with around 2 million items(MS SQL Server DB). It has various products and i want to implement a search functionality for it. The search could be anything like "White shirt" , "Black Shoes", "Leather Belt" so on.

How do i implement the search mechanism ? The site is expected to grow in years.

I know solutions like SQL free-text, Full-text search.

but which one would be appropriate for the scenario. You know people search weird things ?

CURRENT PROBLEM: If a user search "White Shirt" than I search this item from database 5 to 6 times. First search will load the results in website products list. Other searches will get the item count for different search filters.

1. First search will get the item for website search body.
2. Second search will get the counts for discount filter like 5%, 10% or 50% count.
3. Third search will get the counts for category filter like A category, B category and C category count.
4. Fourth search will get the counts for price range. like 0 to 10, 11 to 20 and 21 to 30 range counts.

What is the best solution to perform this kind of search with minimum database calls in efficient way?
Jul 23 '18 #1
Share this question for a faster answer!
Share on Google+

Post your reply

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