osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

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 ...


Go Back   osCommerce and osCMax shopping cart software forums > osCommerce 2.2 Forums > New osCommerce Contributions

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 03-23-2007, 11:00 AM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,329
Thanks: 68
Thanked 322 Times in 305 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Post 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


  • osCMax Templates - Hundreds of premium quality templates. New designs every month!

  • xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience.

  • osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host.

  • osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

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.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax