Re: my paging task with PHP does not work. It uses cookie.
| From: | Patrik Hasibuan | Date: | Thu, 20 Sep 2007 01:29:00 +0000 |
| Subject: | Re: my paging task with PHP does not work. It uses cookie. | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-262264@lists.php.net to get a copy of this message | ||
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@gmail.com> 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@penguin-teknologi.com>
Junior Programmer