problems with SQL_CALC_FOUND_ROWS [repost]

2004-04-26 Thread Arthur Radulescu
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

problems with SQL_CALC_FOUND_ROWS

2004-04-22 Thread Arthur Radulescu
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