Community Add-Ons

Add file to this package
Top » Other

Faster Page Loads, Less DB queries
for osCommerce Online Merchant v2.2

This contribution is to help with page loading times, and with DB queries. Every time a page loads osCommerce,
PHP pulls every row from the configuration table in the database. That's over 170 rows every time, every page load.

I decided to be daring, I am sure against osc developers wishes, but I think this is worth mentioning.

PLEASE KNOW WHAT YOU ARE DOING AND HOW TO HANDLE FILE PERMISSIONS AND REMEMBER TO BACKUP FIRST!!!


How it works:

Every time someone edits a configuration from the configuration box in admin and hits "save" or "submit", the script writes a php file in the folder of your choice (preferably outside the www root) with all the configs from the database. Then, when each page loads, it calls all these configs as an include file, already pulled from the database, instead of querying the database each time and performing the function. I noticed improvement in page load times. Here are some page parse times:

before this change:
08/02/2004 01:55:25 - /index.php?cPath=13 (0.198s)

after the change:
08/02/2004 01:56:14 - /index.php?cPath=13 (0.092s)

Legend:  Download   Report

Expand All / Collapse All

Error Fix: installing/removing modules Denyer 23 Oct 2012  

Included is the full package with extra file to fix problem when add/removing modules

File: Full package + fix

Error: New Module Install Denyer 23 Oct 2012  
Error fix for: Use of undefined constant Debs 3 Nov 2011  
Configuration Cache 1.52 encryped 17 Aug 2011  
Configuration Cache 1.51 encryped 17 Aug 2011  
Configuration Cache 1.50 encryped 16 Aug 2011  
Configuration Cache 1.40 delete13 13 Oct 2009  
Configuration Cache 1.32b - Minor bugfix Phliplip 20 May 2007  
Configuration Cache 1.32 Christophe B. 30 Aug 2004  
minor bug Emmanuel Arnaiz 14 May 2004  
Configuration Cache v1.31 DaemonJ 13 May 2004  
Configuration Cache v1.30a DaemonJ 15 Apr 2004  
Configuration Cache v1.30 DaemonJ 14 Apr 2004  
Configuration Cache v1.20 DaemonJ 6 Apr 2004  
Contribution Cache v1.10 DaemonJ 6 Apr 2004  
Configuration Cache v1.01 corrected for MS1 DaemonJ 5 Apr 2004  
Configuration Cache v1.01 DaemonJ 4 Apr 2004  
Faster Page Loads, Less DB queries Joseph Passavanti 9 Feb 2004  
Faster Page Loads, Less DB queries Joseph Passavanti 8 Feb 2004