Slow LIMIT Query

[Doug V]

When I do a SELECT using STRAIGHT JOIN against multiple tables where the 
main table has about 200k rows, it is very fast retrieving the latest rows, 
ie "LIMIT 0, 10", but extremely slow retrieving older rows, for example, 
"LIMIT 180000 , 10". Doing an EXPLAIN shows that no filesort or temporary 
table is being used. When I do the SELECT without the STRAIGHT JOIN, it does 
do a filesort and is a little bit faster. Is there anyway to speed such a 
query up? Thanks.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]