--- title: How to Increase Performance for Stores with Large Categories and Products description: How to Increase Performance for Stores with Large Categories and Products --- [Skip to content](https://productcart-kb.nsource.com/kb/how-to-increase-performance-for-stores-with-large-categories-and-products1#main-content) [![pc\_logo](https://productcart-kb.nsource.com/hs-fs/hubfs/pc_logo.png?width=162&height=75&name=pc_logo.png)](https://productcart.com/) Open main navigation Close main navigation - - [Contact Support](mailto:help@productcart.com) [Contact Support](mailto:help@productcart.com) How can we help you? - There are no suggestions because the search field is empty. 1. [ProductCart Help Center](https://productcart-kb.nsource.com/kb?hsLang=en) 2. [How To's](https://productcart-kb.nsource.com/kb/how-tos?hsLang=en) March 5, 2024 # 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. - [Managing Your Products](https://productcart-kb.nsource.com/kb/managing-your-products?hsLang=en) - [Managing Orders](https://productcart-kb.nsource.com/kb/managing-orders?hsLang=en) - [Managing Customers](https://productcart-kb.nsource.com/kb/managing-customers?hsLang=en) - [Getting Started](https://productcart-kb.nsource.com/kb/getting-started?hsLang=en) - [Apparel Add-On](https://productcart-kb.nsource.com/kb/apparel-add-on?hsLang=en) - [Upgrading ProductCart](https://productcart-kb.nsource.com/kb/upgrading-productcart?hsLang=en) - [Change Logs](https://productcart-kb.nsource.com/kb/change-logs?hsLang=en) - [Store Settings](https://productcart-kb.nsource.com/kb/store-settings?hsLang=en) - [Security](https://productcart-kb.nsource.com/kb/security?hsLang=en) - [Shipping Options](https://productcart-kb.nsource.com/kb/shipping-options?hsLang=en) - [Payment Options](https://productcart-kb.nsource.com/kb/payment-options?hsLang=en) - [Tax Options](https://productcart-kb.nsource.com/kb/tax-options?hsLang=en) - [Advanced Technical Articles](https://productcart-kb.nsource.com/kb/advanced-technical-articles?hsLang=en) - [Pages](https://productcart-kb.nsource.com/kb/pages?hsLang=en) - [What's New In ProductCart](https://productcart-kb.nsource.com/kb/whats-new-in-productcart?hsLang=en) - [Marketing](https://productcart-kb.nsource.com/kb/marketing?hsLang=en) - [How To's](https://productcart-kb.nsource.com/kb/how-tos?hsLang=en) - [Google Analytics](https://productcart-kb.nsource.com/kb/google-analytics?hsLang=en) - [QuickBooks Sync](https://productcart-kb.nsource.com/kb/quickbooks-sync?hsLang=en) - [Default](https://productcart-kb.nsource.com/kb/default?hsLang=en) - [Configurator](https://productcart-kb.nsource.com/kb/configurator?hsLang=en) - [SEO](https://productcart-kb.nsource.com/kb/seo?hsLang=en) - [Mobile Commerce](https://productcart-kb.nsource.com/kb/mobile-commerce?hsLang=en) - [Troubleshooting](https://productcart-kb.nsource.com/kb/troubleshooting?hsLang=en) - [Customizing Your ProductCart Store](https://productcart-kb.nsource.com/kb/customizing-your-productcart-store?hsLang=en) - [ProductCart Apps](https://productcart-kb.nsource.com/kb/productcart-apps?hsLang=en) - [Hidden Topic](https://productcart-kb.nsource.com/kb/hidden-topic?hsLang=en) - [Reports and Exports](https://productcart-kb.nsource.com/kb/reports-and-exports?hsLang=en) [![ProductCart Logo](https://productcart-kb.nsource.com/hs-fs/hubfs/pc_logo.png?width=200&height=93&name=pc_logo.png "ProductCart Logo")](https://netsourceinc.com) NetSource Commerce, Inc. **|** Headquarters - 3700 South Pine Avenue, Ocala, FL 34471 **|** Tel [(800) 709-3240](tel:+8007093240) **|** Fax (352) 401-0353 [mailto:help@productcart.com](mailto:help@productcart.com) Copyright © 2026, NetSource