MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Doug V Date:July 10 2004 5:27pm
Subject:Re: How to Speed this Query Up? (Solved)
View as plain text  
Using INNER JOINs with the STRAIGHT_JOIN option so that the main table 
displayed first in the EXPLAIN eliminated the temporary table being created 
and the query speed went from 2.3 seconds to 0.2 seconds. Note that this 
only works for queries where the offset in the LIMIT is small. As the offset 
approaches the total row count, the speed gradually decreases, so much so 
that the query eventually goes from 2.3 seconds to 4.6 seconds. However 
since the first few pages (newest data)are accessed most of the time, this 
is not a problem.


Re: How to Speed this Query Up? (Solved)Doug V10 Jul