R12 search slow when many Product.SearchKeyword values

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

R12 search slow when many Product.SearchKeyword values

Post by AbleMods » Thu Oct 27, 2016 4:51 am

We tried a test to resolve the lack of a variant SKU search feature by populating the SearchKeywords field of each product with all possible variant skus.

This worked, but the resulting search is painfully slow. Like 30 seconds to find 1 product. Most of the time burden is in the search sidebar control where it tries to count the results for each subcategory. In this case, there are a minimum of 18 root categories and hundreds of subcategories.

Any thoughts or suggestions on how to improve the search speed when SearchKeywords has a lot of values? Or a better solution that offers searching by variant sku?
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
efficiondave
Commander (CMDR)
Commander (CMDR)
Posts: 151
Joined: Tue Dec 02, 2008 10:20 am
Location: St. Louis Missouri
Contact:

Re: R12 search slow when many Product.SearchKeyword values

Post by efficiondave » Wed Jan 24, 2018 7:38 am

I also need a solution that allows keyword search to include all skus. It's surprising to me this isn't already handled.

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: R12 search slow when many Product.SearchKeyword values

Post by Katie » Thu Jan 25, 2018 11:31 am

Or a better solution that offers searching by variant sku?
It was added in AbleCommerce Gold R9.
Issue AC8-2589 (SQL Provider) Search by product SKU should also be searching the ac_ProductVariants Sku table
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

Post Reply