Re: BIG (up to 45%) performance increase for categorybox.php
judgej <[email protected]> 27 Aug 2003 10:15:40 -0000
| Newsgroups | gmane.comp.web.oscommerce.suggestions |
|---|---|
| Message-ID | <f68b6772467165765ffac4cfdb02d89f@osCommerce-Forums> |
This message was sent from: Suggestions and Proposals http://forums.oscommerce.com/viewtopic.php?p=220339#220339 ---------------------------------------------------------------- I'm not entirely sure what the proposal here is, but I got a substantial performance gain on the categories box just by adding an index to osc_categories.x_categories_parent_id This turned an unusably slow shop with 100+ categories into a shop with the same speed as 10 categories. An index on osc_products_to_categories.categories_id (can't remember if that is one I added, or is part of the base install) also helps performance. -- Jason