note 52375 added to function.mysql-num-rows
| From: | alexdotfeinberg4tgm41l at osu1 dot php dot net | Date: | Thu, 28 Apr 2005 22:56:12 +0000 |
| Subject: | note 52375 added to function.mysql-num-rows | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-88721@lists.php.net to get a copy of this message | ||
Re dzver at abv dot bg's note...
I just ran some tests using MySQL Super Smack. Surprisingly, a SELECT * followed by a SELECT
COUNT(*) actually was close in speed to a SELECT SQL_CALC_FOUND_ROWS * followed by a SELECT
FOUND_ROWS(), but the SQL_CALC_FOUND_ROWS solution was still a bit faster.
Perhaps it varies by table structure? Either way, it might be worth checking which is faster for
your application.
----
Manual Page -- http://www.php.net/manual/en/function.mysql-num-rows.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+52375
Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+52375&report=yes&reason=added+to+the+manual
Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+52375&report=yes&reason=bad+code
Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+52375&report=yes&reason=spam
Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+52375&report=yes&reason=useless
Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+52375&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+52375&report=yes
Search -- http://master.php.net/manage/user-notes.php