Re: Optimize a query
Posted by:
Rick James
Date: March 15, 2011 09:12PM
If you get tight for memory, you can lower the key_buffer_size again. I see only 3MB of indexes in those tables. (Are those all the tables?) MyISAM indexes are cached in the key_buffer.
The SELECT returns 24K rows?
What happens if you
ALTER TABLE jos_clothes_products ADD INDEX(created_on, ordering);
Does the query via the VIEW become faster?
Does the equivalent query without the VIEW become faster?
Subject
Views
Written By
Posted
2918
March 10, 2011 08:59AM
1430
March 13, 2011 03:48PM
1499
March 14, 2011 03:35PM
1510
March 14, 2011 06:26PM
1365
March 15, 2011 02:20PM
Re: Optimize a query
1406
March 15, 2011 09:12PM
1306
March 28, 2011 06:20AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.