Shopping Cart Software
parent_id Query Optimisation
This is a discussion on parent_id Query Optimisation within the New osCommerce Contributions forums, part of the osCommerce 2.2 Forums category; catalog>index.php calls tep_get_path() in catalog>includes>functions>general.php for each link so there are multiple queries. Especially if you have a parent category ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
03-23-2007, 11:00 AM
| ||||
| ||||
 parent_id Query Optimisation catalog>index.php calls tep_get_path() in catalog>includes>functions>general.php for each link so there are multiple queries. Especially if you have a parent category with multiple children. The queries look like .. Select parent_id from categories where parent_id = X You could potentially have 100s of these. This contribution reduces it to one query regardless of the number of child categories you may have. More...
__________________ Michael Sasek osCMax Developer
    |
 |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| SQl Query error | dmiles | osCMax v2 Customization/Mods | 2 | 03-05-2007 11:42 PM |
| fck editor query | Lara Croft | osCMax v2 Customization/Mods | 3 | 01-25-2007 04:39 PM |
| ssl query | Lara Croft | osCMax v2 Installation issues | 2 | 12-30-2006 12:22 PM |
| General Support Query | jarb | osCMax v2 Features Discussion | 3 | 11-24-2006 05:59 AM |
| Shooping Cart Query | kama_k | osCommerce 2.2 Modification Help | 3 | 12-19-2004 08:06 AM |
All times are GMT -8. The time now is 02:53 PM.
