Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 29.990.292 Times

Faster Page Loads, Less DB queries 1.32b 1.0

  Date Added: May 10, 2013  |  Visits: 267

Faster Page Loads, Less DB queries 1.32b

Report Broken Link
Printer Friendly Version


Product Homepage
Download (27 downloads)

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)

Requirements: No special requirements
Platforms: Windows, *nix, Linux, PHP , BSD
Keyword: Faster Faster Page Loads Oscommerce Addons Page Page Loads
Users rating: 0/10

License: Freeware
FASTER PAGE LOADS, LESS DB QUERIES 1.32B RELATED
Modules  -  Bestselling Products Page 1.0.1
This contribution creates a NEW page on osCommerce that lists your BEST SELLING PRODUCTS in ROWS, similar to how the New Products page looks, complete with product image, product name, product price and "more info" and "buy now" links.(This does...
 
Modules  -  404 Search Page 1.0
This contribution allows you to setup a customer error page that takes the URL and searches for matching products.When you upgrade to a new Oscommerce site your page name will all change and the search engines will link to the old files for...
 
Modules  -  Hide Page Counter 1.1
This simple contribution will add an option to your Admin - My Store configuration page to allow for the enabling and disabling of the displaying of the store page hit counter. This will simply hide the counter, and should not interfere with it...
 
Modules  -  Specials Page Displayed Like New Products Page 1.0
This mod makes 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!!!!!
 
Graphic Conversion Tools  -  Viscom Store TIFF Add Page 1.02
Free tool allow add single or multi-page TIFF file to specific page from Multi-page TIFF file. Preview updated TIFF file.
15.16 MB  
Modules  -  phpbb Page Generation Time 2.0.1
This MOD will show page generation info in the page footerEg: Page generation time: 0.4873s (PHP: 83% - SQL: 17%) - SQL queries: 14 - GZIP enabled - Debug on
 
Modules  -  Breadcrumb Trail Page Title 1.0
A simple mod that changes the page title of catalog pages to mirror the breadcrumb trail.Created on the 8/28 snapshot.
 
Modules  -  Quick Research Infobox with Page Result 1.01
It allows to search for product using keywords, price range, category and manufacturer like as "advanced search page" but more simple and fast and not force the customers insert data in any field (in this case all products is returned).The...
 
Modules  -  Product Page Substitution 1.0
The advantage of this is that through the POST variables, you can select a different page to display, essentially allowing you to have multiple pages for a single product. You would, of course, need to provide the links to the secondary pages, but...
 
Libraries  -  Template::Plugin::Page 0.10
Template::Plugin::Page is a plugin to help when paging through sets of results. SYNOPSIS [% USE page = Page($total_entries, $entries_per_page, $current_page) %] First page: [% page.first_page %] Last page: [% page.last_page %] First entry...
3.07 KB  
NEW DOWNLOADS IN SCRIPTS, MODULES
Scripts  -  Free Ecommerce website creator 1.2
Free Ecommerce website creator is a free PHP shop creating script. This allows you to put a online shop on your own website. Create your own free ecommerce website for Your Business. Create an online shop using easyGUI online shop creator. The...
1.44 KB  
Scripts  -  MochiGames PHP Script ZDR 1.00
MochiGames PHP Script ZDR is web site, ready for use, for flash games. These flash games are downloaded automatically by "MochiGames PHP Script ZDR" from MochiGames media. The use of the games is free, you can use your own Mochi Publisher ID and...
368.54 KB  
Scripts  -  Php Chat 2.0
Add a free php site, single sign-on and multiple skins, 100% free 1. Server Modes: The chat server has paid mode and free mode. If the free chat mode, a free chat room will be assigned to your website with your domain as the room name. 2....
938.87 KB  
Scripts  -  Nibbleblog 3.0.1
Nibbleblog it's a powerful engine for creation and manipulation of BLOG's completely free. Very simple to install and configure (Only 1 step). The database used is based on XML files and this way it is not necessary to use MySQL or similar DBMS....
371.09 KB  
Scripts  -  PHP File Manager | CloudOsys 2.9b8
CloudOsys is a PHP file manager, a tool that allows your visitors upload files such as media content directly to your website. Your visitors will upload files directly to your website, where they can share and comment on them. Through cloud...
1.41 MB  
Modules  -  TinyMCE Node Picker 6.x-2.1
This module will de discontinued and replaced with Node Picker as soon as a stable release is available.TinyMCE Node Picker provides a button in TinyMCE that displays a list of links to content. Choosing a link inserts it into the editor.The...
20.48 KB  
Modules  -  Fapilicious 5.x-1.x-de
Fapilicious is a collection of FormAPI goodies.I hope to make it a repository of reusable FormAPI trickery and short cuts. Currently it has small collection of powerful FormAPI element validators.Please submit your favorite tricks as patches so we...
10 KB  
Modules  -  Donation Goals 6.x-1.x-de
The Donation Goals module lets you create nodes of the type "Donation Goal." These goals allow you to set an amount of money you'll need for whatever you're saving up for. Visitors of the site can then donate money through PayPal. Once the target...
20.48 KB  
Modules  -  Plica Twitter 1.0.1
Plica TwitterInstallation : * Download, unzip, and install plugin dir in /wp-content/plugins * Activate * All right now
10 KB  
Modules  -  Page Array 5.x-1.x-de
The pagearray module is a small (single function) helper module that can be used whenever there is a need to load the output of any Drupal path in data form. Based on the code in index.php, Page Array bypasses the theme('page') call, instead...
10 KB