Faster Page Loads Less DB queries

Faster Page Loads, Less DB queries 1.32b

Faster Page Loads, Less DB queries 1.32b Download Summary

  • Language: PHP
  • Platform: Windows / Linux / BSD
  • License: GPL - GNU Public License
  • Databases: MySQL
  • Downloads: 367
  • Released: Jun 15, 2007

Faster Page Loads, Less DB queries 1.32b Description

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)

Faster Page Loads, Less DB queries 1.32b Keywords

Faster Page Loads Less DB queries Bookmark

Hyperlink code:
Hyperlink for Forum code:

Faster Page Loads, Less DB queries 1.32b Script Download Notice

Top 4 Download periodically updates information of Faster Page Loads, Less DB queries 1.32b script from the developer, but some information may be slightly out-of-date.

Our script download links are directly from our mirrors or publisher's website. Faster Page Loads, Less DB queries 1.32b torrent files or shared files from free file sharing and free upload services, including Rapidshare, MegaUpload, YouSendIt, MailBigFile, DropSend, HellShare, HotFile, FileServe, MediaMax, zUpload, MyOtherDrive, SendSpace, DepositFiles, Letitbit, LeapFile, DivShare or MediaFire, are not allowed!

Product picture in new style

... the picture won`t crimpled and looks good and loads a lot faster than the big one. When you press on the picture it generates a biger picture in the window. ...

Support Ticket Search

... find details of a support ticket that was faster than manually scrolling through all the ticket items page by page.This still needs to integrate with the support tickets ...

Admin dhtml menu

... navigation) with horizontal dhtml menu in admin.Features:- Reduces page loads. - Takes up less space ...

Page Cache

This contribution caches pages while allowing dynamic elements such as shopping cart ... is designed to decrease server load and increase page performance. ...

Specials Page Displayed Like New Products Page

... the products display just like the New Products page. (products_new.php)Easy to install. Simply upload my new specials.php file into your server, so that it overwrites the old one.REMEMBER TO BACK UP FIRST!!!!! ...