Jump to content

query optimization help


iconsis

Recommended Posts

[code]select count(distinct p.products_id) as total from products p
left join manufacturers m using(manufacturers_id), products_description pd
left join specials s on p.products_id = s.products_id, categories c, products_to_categories
p2c,products_attributes pa where p.products_status = '1' 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[/code]

  above query is used with custom oscommerce site, pls any one to optimize this query. because this is query take more query timing and server problem.

Best Regards,
iconsis online.
Link to comment
https://forums.phpfreaks.com/topic/30367-query-optimization-help/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.