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

Dramatically Improve Search Speed 1.0

  Date Added: May 10, 2013  |  Visits: 220

Dramatically Improve Search Speed

Report Broken Link
Printer Friendly Version


Product Homepage
Download (27 downloads)



I finally figured out what was bogging down my database when searching for products. I had to post this. I have about 220,000 active products in my store seekshopping.com... parse time is at the bottom if anyone wants to checkout the performance.I have optimized so many queries and continue to monitor and do so. Whe I started, my search queries were about 20-40 seconds... that's a life time on the net. Including all the variables in the search url with help decrease query speed by about 50%...keywords=wars&search_in_description=1&categories_id=&inc_subcat=1&medium=&pfrom=&pto=&dfrom=&dto=Now I'm down to about 11 or 12 seconds for a search which is still not good enough. 6 seconds should be the maximum. Just remove products_model from the search string. Here is the code to change in advanced_search_result.php...Comment this out://$where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%'";Simply change to this:$where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%'";I hope this helps someone out. My queries are running under half a second and my search page parses in about 2 seconds. That's a 1500% imporvement.

Requirements: No special requirements
Platforms: Windows, *nix, Linux, PHP , BSD
Keyword: Dramatically Dramatically Improve Improve Oscommerce Addons Search Search Speed
Users rating: 0/10

License: Freeware
USER REVIEWS
More Reviews or Write Review


DRAMATICALLY IMPROVE SEARCH SPEED RELATED
Modules  -  admin/site - separate search results display 1.0
Search result in www section and diplay in admin section are being governed by the same MAX_DISPLAY_SEARCH_RESULTS value. When you choose to display just a few (eg.2) results on www (for design purposes) your admin section becomes unlivable - try...
 
Modules  -  Default Search options in categories and Advanced 1.0
This Contribution will tell you how to adjust your files to allow you to change the default search criteria in the normal browse by category and the advanced search page.2 files need to be adjusted, instructions can be found in the attached zip...
 
Modules  -  Firefox Search Plugin for OSC shops 1.0
This plugin is a Mozilla Firefox one, not really an oscommerce contribution. With this your customers will be able to add your site to the search engine box included in Firefox.This is specific to Firefox, it doesn't work with IE...
 
Modules  -  Statistic Search Keywords 1.0
Statistic Search Keywords save the keywords there used in the Search Engine of the Shop-site.It can be helpful to know what kind of parts searching potential customers or customers.
 
Modules  -  Attributes Search 3.1
One of our carts has over 500 attributes that are displayed, and finding one is more of a guessing game of clicking on a page number and pinpointing the one you want to find.So I created a simple search method to admin/product_attributes.php to...
 
Modules  -  SEF Link Transformer 0.5.0a 1.0
This script transform almost all links on your osCommerce shop to "Search Engine Friendly" format. Like "SE friendly URLs" option, but i think it works better.
 
Network & Internet  -  ASPseek 1.2.10
ASPseek is an Internet search engine software developed by SWsoft and licensed as free software under GNU GPL. ASPseek consists of an indexing robot, a search daemon, and a CGI search frontend. It can index as many as a few million URLs and...
46.08 KB  
Modules  -  Index CCK Node Reference 5.x-0.1-beta1 1.0
This module works with both the Search and Fuzzy Search search engines.InstallationUnpack in your modules folder (usually /sites/all/modules/) and enable under Administer > Site Building > Modules. Requirements: - Drupal 5.x - Drupal Content...
 
Business  -  Excelling 2.0
Discover, Learn and even Share the Excel Function you need, when you need it. Highlights: - Smart Search: type what you are interested in and choose the formula you need. - Name Search: search by function name & category. -...
15.5 MB  
Server Tools  -  ForumFinderBuzz 1
forum finder tool for searching homes for sale in palos verdes, rolling hills, palos verdes estates, rancho palos verdes, rolling hills estates, redondo beach, manhattan beach, hermosa beach, torrance, california foreclosures, free search, search...
2.06 MB  
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