except i think innodb does not have a full row count stored. anyway the design was meant for a simple one function call. it's worked great for small and data loads. On 9/14/07, Arvids Godjuks <arvids.godjuks@xxxxxxxxx> wrote: > Don't use SQL_CALC_FOUND ROWS on simple queries, when you have to run a > simple query on one or two (with join) tables with a simple WHERE. Especialy > if tables are big. I found out that single SELECT COUNT(id) FROM table is > far more faster when query has simple WHERE conditions. I use > SQL_CALC_FOUND_ROWS only with a rather complex queries - that > SQL_CALC_FOUND_ROWS doesn't affect query execution at all (well, it affects > ofcourse, but affect is so small, you can't see it). -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
