RE: [PHP] paging methodology
| From: | Brad Pauly | Date: | Wed, 05 May 2004 18:33:29 +0000 |
| Subject: | RE: [PHP] paging methodology | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-185473@lists.php.net to get a copy of this message | ||
On Wed, 2004-05-05 at 12:23, Chris wrote:
> It's certainly faster than "SELECT COUNT(*) FROM sometable WHERE . . .";
>
> It might not be faster than "SELECT COUNT(*) FROM sometable", as that is
> designed to run very quickly.
I believe it will also depend on the type of table you are using.
"SELECT COUNT(*) FROM sometable" is much faster with MyISAM tables than
with InnoDB tables because InnoDB tables need to actually count all the
rows where MyISAM tables keep that information handy. Someone please
correct me if I got that wrong.
- Brad