This is a discussion on sql queries overloading my hosts, what to do? within the osCMax v1.7 Installation forums, part of the osCMax v1.7 Forums category; According to my host, queries are causing overloading of the servers. Host says: The problem is, whenever someone visits the ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| According to my host, queries are causing overloading of the servers. Host says: The problem is, whenever someone visits the site, a bunch of mysql processes such as this occurs: | 3166 | nationa_jacob | localhost | nationa_oscmax | Query | 95 | Copying to tmp table on disk | select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_product | | 3172 | nationa_jacob | localhost | nationa_oscmax | Query | 34 | Copying to tmp table on disk | select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_product | I'm not really sure what to do here. Our account may be suspended unless we figure this out. Any help is appreciated. Jacob |
| Sponsored Links | ||
| ||
| |
|
#2
| ||||
| ||||
| these are normal queries performed by OSC to display products for your customers. Maybe you need a host specializing in OSC hosting like AABOX or US, See our signature line
__________________ Clifton Murphy CEO/CTO Hyperactive Inc. osCommerce hosting, OSCMAX hosting, osCommerce modification, and OSCMAX modification specialists! |
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| changed hosts and urls, what can I do now? | [wicked] | osCMax v2 Installation issues | 1 | 01-28-2006 10:39 PM |
| So Many Queries so little time | delphi1 | osCMax v2 Customization/Mods | 10 | 11-07-2005 04:02 AM |
| securing and storing database queries | fun2bnuts | osCMax v2 Installation issues | 2 | 06-26-2005 09:09 PM |
| Custom Queries | know | osCommerce 2.2 Modification Help | 1 | 10-29-2002 10:14 AM |