But i give you a suggestion (theoritical) : if data are reverse sorted , LIMIT 180000, 10 will be LIMIt 20000, 10
who knows ? Mathias Selon [EMAIL PROTECTED]: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
