osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

Optimize categories box

This is a discussion on Optimize categories box within the New osCommerce Contributions forums, part of the osCommerce 2.2 Forums category; It is common knowledge that displaying the numbers of products in the categories box (Configuration -> My Store -> Show ...


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

Optimize categories box Optimize categories box

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Reply

 

LinkBack Thread Tools
  #1  
Old 05-26-2007, 10:42 AM
michael_s's Avatar
osCMax Developer

  
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 11,100
Thanks: 81
Thanked 348 Times in 327 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 Optimize categories box
It is common knowledge that displaying the numbers of products in the categories box (Configuration -> My Store -> Show Category Counts = true) generates a large numbers of queries.
This small contribution slashes the numbers of queries on the front page of the default installation of osCommerce from 83 to 43 (so about two per category, showing the number of products per category) by querying most of the information needed in two queries (total) and storing/retrieving the results in/from an object. It is also used to cut the number of queries for the categories box needed.

More...
__________________
Michael Sasek
osCMax Developer

  • osCMax Templates - Hundreds of premium quality templates designed for osCMax 2. Loyalty discounts up to 30% off!
    Each purchase supports the osCMax project with much needed funds!
  • 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. Default multi server configuration for exceptional performance!

  • 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!
Reply With Quote
Sponsored Links
Advertisement
Reply

« Super Contact us enhancement 1.0 | Realex Payments »
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
Categories XC michael_s New osCommerce Contributions 0 02-12-2007 02:18 PM
How can I optimize my site for the best search engine result groggory osCMax v2 Customization/Mods 5 02-08-2006 03:13 PM
Want to show categories AND sub categories in index.php!! calle osCommerce 2.2 Modification Help 0 10-27-2004 12:51 PM
CATEGORIES BOX does not display categories list glk osCMax v1.7 Discussion 2 03-05-2004 11:09 AM
categories in MS2 Max gellnsh osCMax v1.7 Discussion 1 09-25-2003 02:43 PM


All times are GMT -8. The time now is 09:45 PM.

osCMax Home - Site Map - Top

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