Hi Arvid, thank you very much for your remark. It is useful for me. === On Fri, 14 Sep 2007 12:01:40 +0300 "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). > -- Patrik Hasibuan <patrikh@xxxxxxxxxxxxxxxxxxxxx> Junior Programmer -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
