urgent help needed.
it looks like every database query goes through the entire database:
Rows_sent: 123570 Rows_examined: 371018 (see mySQL log below).
Anybody can help with this?
# Query_time: 5 Lock_time: 0 Rows_sent: 123570 Rows_examined: 371018
select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
p.products_date_added, p.products_price, p.products_type, p.master_categories_id
from zen_products p, zen_products_description pd
where p.products_id = pd.products_id
and pd.language_id = '1'
and p.products_status = 1;
Bookmarks