Pair.com tells me queuries are too long - help

[smartwork]

Pair.com (host of this forum site, I think) tells me my queries are too long. They unexpectantly shut down access to our database today which shut down our store. We need to resolve this issue. Here is a snippet query they sent. Is this normal? How can this be shortened or made more efficient so that our site doesn't get shut down again?

 

What we were told:

 

<<From what we are seeing average connections to the database are producing

~100 queries per process access. The queries should be made more efficient

to better utilize the database service. The large number of queries

per process does not scale well so any increase in traffic may cause

stability problems>>

 

 

 

 

 

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select c.categories_id, cd.categories_name, c.parent_id, c.categories_image

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

12410649 Query select distinct m.manufacturers_id as id, m.manufacturers_name as name from products p, products_to_categories p2c, manufacturers m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '57' order by m.manufacturers_name

12410649 Query select categories_image from categories where categories_id = '57'

12410649 Query select categories_headtext from categories_description where categories_id = '57'

12410649 Query select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50'

12410649 Query select coun*) as count from banners_history where banners_id = '5' and date_formabanners_history_date, '%Y%m%d') = date_formano), '%Y%m%d')

12410649 Query update banners_history set banners_shown = banners_shown + 1 where banners_id = '5' and date_formabanners_history_date, '%Y%m%d') = date_formano), '%Y%m%d')

12410649 Query select coun*) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '57'

12410649 Query select p.products_image, p.products_model, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, Is.status, s.specials_new_products_price, NULL) as specials_new_products_price, Is.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '57' order by pd.products_name limit 0, 15

12410649 Query select products_name from products_description where products_id = '67' and language_id = '1'

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') andza.zone_id is null or za.zone_id = '0' or za.zone_id = '56') and tr.tax_class_id = '1' group by tr.tax_priority

12410649 Query select products_name from products_description where products_id = '754' and language_id = '1'

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') andza.zone_id is null or za.zone_id = '0' or za.zone_id = '56') and tr.tax_class_id = '1' group by tr.tax_priority

12410649 Query select products_name from products_description where products_id = '376' and language_id = '1'

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') andza.zone_id is null or za.zone_id = '0' or za.zone_id = '56') and tr.tax_class_id = '1' group by tr.tax_priority

12410649 Query select products_name from products_description where products_id = '378' and language_id = '1'

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') andza.zone_id is null or za.zone_id = '0' or za.zone_id = '56') and tr.tax_class_id = '1' group by tr.tax_priority

12410649 Query select products_name from products_description where products_id = '377' and language_id = '1'

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') andza.zone_id is null or za.zone_id = '0' or za.zone_id = '56') and tr.tax_class_id = '1' group by tr.tax_priority

12410649 Query select products_name from products_description where products_id = '674' and language_id = '1'

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') andza.zone_id is null or za.zone_id = '0' or za.zone_id = '56') and tr.tax_class_id = '1' group by tr.tax_priority

12410649 Query select products_name from products_description where products_id = '653' and language_id = '1'

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') andza.zone_id is null or za.zone_id = '0' or za.zone_id = '56') and tr.tax_class_id = '1' group by tr.tax_priority

12410649 Query select products_name from products_description where products_id = '563' and language_id = '1'

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') andza.zone_id is null or za.zone_id = '0' or za.zone_id = '56') and tr.tax_class_id = '1' group by tr.tax_priority

12410649 Query select products_name from products_description where products_id = '658' and language_id = '1'

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') andza.zone_id is null or za.zone_id = '0' or za.zone_id = '56') and tr.tax_class_id = '1' group by tr.tax_priority

12410649 Query select products_name from products_description where products_id = '461' and language_id = '1'

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') andza.zone_id is null or za.zone_id = '0' or za.zone_id = '56') and tr.tax_class_id = '1' group by tr.tax_priority

12410649 Query select products_name from products_description where products_id = '672' and language_id = '1'

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') andza.zone_id is null or za.zone_id = '0' or za.zone_id = '56') and tr.tax_class_id = '1' group by tr.tax_priority

12410649 Query select products_name from products_description where products_id = '747' and language_id = '1'

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') andza.zone_id is null or za.zone_id = '0' or za.zone_id = '56') and tr.tax_class_id = '1' group by tr.tax_priority

12410649 Query select products_name from products_description where products_id = '462' and language_id = '1'

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') andza.zone_id is null or za.zone_id = '0' or za.zone_id = '56') and tr.tax_class_id = '1' group by tr.tax_priority

12410649 Query select products_name from products_description where products_id = '297' and language_id = '1'

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') andza.zone_id is null or za.zone_id = '0' or za.zone_id = '56') and tr.tax_class_id = '1' group by tr.tax_priority

12410649 Query select products_name from products_description where products_id = '34' and language_id = '1'

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') andza.zone_id is null or za.zone_id = '0' or za.zone_id = '56') and tr.tax_class_id = '1' group by tr.tax_priority

12410649 Query select products_id, products_image, products_tax_class_id, products_price from products where products_status='1' order by products_date_added desc limit 10

12410649 Query select products_name from products_description where products_id = '77' and language_id = '1'

12410649 Query select specials_new_products_price from specials where products_id = '77' and status

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') andza.zone_id is null or za.zone_id = '0' or za.zone_id = '56') and tr.tax_class_id = '1' group by tr.tax_priority

12410649 Query select distinct p.products_id, pd.products_name, p.products_ordered from products p, products_description pd, products_to_categories p2c, categories c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id andc.categories_id = '57' OR c.parent_id = '57') order by p.products_ordered DESC, pd.products_name limit 5

12410649 Query select products_id, products_image, products_tax_class_id, products_price from products where products_status='1' limit 10

12410649 Query select products_name from products_description where products_id = '38' and language_id = '1'

12410649 Query select specials_new_products_price from specials where products_id = '38' and status

12410649 Query select sutax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za ontr.tax_zone_id = za.geo_zone_id) left join geo_zones tz ontz.geo_zone_id = tr.tax_zone_id) whereza.zone_country_id is null o

[Guest]

install the Optimize tep_get_tax_rate() contribution...

 

Bobby