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?
R12 search slow when many Product.SearchKeyword values
R12 search slow when many Product.SearchKeyword values
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
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
- efficiondave
- 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
I also need a solution that allows keyword search to include all skus. It's surprising to me this isn't already handled.
David O'Leary
http://www.EfficionConsulting.com
http://www.EfficionConsulting.com
Re: R12 search slow when many Product.SearchKeyword values
It was added in AbleCommerce Gold R9.Or a better solution that offers searching by variant sku?
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
http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support