Hello,
I built a "narrow by" feature for an ecommerce store. You can view an example of a narrow by feature here:
http://www.walmart.com/browse/Computers/Laptop-Computers/All-Laptop-Computers/_/N-3xtzZaq9c?&ic=48_0&path=0:3944&ref=125875.183815+500000.500592&catNavId=4070
Essentially what it does is allow you to select options like "color" or "size" to narrow down your choices. It counts the number of results you will view if you select that link.
My feature works ok, but when the store added about 18,000 products to their database the performance crashed. The issue is that it has to count the number of results for every possible selection when the page loads. Otherwise, you risk showing an option that will return no results. So basically I am executing dozens of scalar queries against a very large database every time the page loads.
I am new to ASP.NET a ...
Go to the complete details ...