Skip to content
  • There are no suggestions because the search field is empty.

How to Increase Performance for Stores with Large Categories and Products

Please note: The contents of this article apply only to licensed versions of the ProductCart software. They do not apply to stores running as a hosted application under a ProductCart Live agreement.




Fine Tuning your Search Fields

If you are using ProductCart and your store falls into any of the following scenarios, then additional tuning methods may apply to you and may allow you to further improve performance.
 
  • Complex Category Structure
  • Apparel Add-on in use and thousands of sub-products in the database
  • Thousands of product with large HTML descriptions

Complex Category Structure

If your store has dozens of categories containing dozens of sub-categories and the search results hang, then you may want to disable category search results. Follow these instructions to turn off category search results:
 
  1. Download the file "pc/showsearchresults.asp" using your favorite FTP software
  2. Save a back-up copy
  3. Open the file in a text editor
  4. Replace the word False on line 19 with True
  5. Save the file and upload it back to the server

Thousands of Sub-Products

You may want to disable sub-product search to increase site performance.
 
  1. Download the file "pc/showsearchresults.asp" using your favorite FTP software
  2. Save a back-up copy
  3. Open the file in a text editor
  4. Replace the word False on line 24 with True
  5. Save the file and upload it back to the server
  6. Now download the file "pc/inc_srcPrdQuery". Save a back-up copy
  7. Open the file in the text editor
  8. Replace the word False on line 5 with True
  9. Save the file and upload it back to the server
 

Thousands of Products with Large HTML Descriptions

  1. Download the file “pc/showsearchresults.asp” using your favorite FTP software.
  2. Save a back-up copy.
  3. Open the file in a text editor.
  4. Replace all occurrences of the word A.details with A.pcProd_MetaKeywords. It is helpful to use a text editor with a good Find and Replace feature, such as Dreamweaver.
  5. Save the file and upload it back to the server.
  6. Now download the file “pc/inc_srcPrdQuery”. Save a back-up copy.
  7. Open the file in a text editor.
  8. Replace all occurrences of the word A.details with A.pcProd_MetaKeywords
  9. Save the file and upload it back to the server.