Hi, i and i think all people will think the same : i can't help. why ? have you described your tables ? have your given the size of each table ? have you list the indexes ? have you specify the storage type ? and have you given the query ?
if you're looking for just a theoritical response, docs.mysql.com can give it. and sorry, this is not an ofense . Mathias Selon Doug V <[EMAIL PROTECTED]>: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
