Hello! I am facing a problem when using SQL_CALC_FOUND_ROWS in certain queries.
The query where I am ordering by a column is much more slowly than the same query NOT using SQL_CALC_FOUND_ROWS select SQL_CALC_FOUND_ROWS * from table by date desc - this query takes about 1.2 s select * from table by date desc - this query takes about 0.1 s I have tried with or without an index on the column date... Also tried to force the index but still not success Using explain I have noticed that the first query is using filesort and I cannot figure out why exactly... I could use count() to figure out the total number of results for the navigation and this would be defintelly much faster sbut I was thinking if anyone else had this problem before and if you have found any work around... BTW after some checkings I have discovered that this is more or less a bug as seen here http://bugs.mysql.com/bug.php?id=1274 But after I have read everything and tried all possibilities I think this is a little different and I do not know if there is any workaround for this issue... Thanks, Arthur -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
