[snip]
# Time: 050107 17:40:41
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 13 Lock_time: 0 Rows_sent: 148 Rows_examined: 1567270
use zencarttest;
select distinct m.manufacturers_id, m.manufacturers_name from
zen_manufacturers m
left join zen_products p on m.manufacturers_id =
p.manufacturers_id
where m.manufacturers_id = p.manufacturers_id and
p.products_status= '1'
order by manufacturers_name;
[/snip]
This appears to be the problem query. Looks like zen_products could use an
index on (manufacturers_id, products_status), and zen_manufacturers could
use an index on (manufacturers_id,manufacturers_name).
You can try to add these indexes and run the query to see if it helps. You
may want to do an EXPLAIN after adding the indexes to make see if it is
using them.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
