Re: IBM's Learning PHP Part 1 tutorial.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Richard Davey wrote:
Hello André,

Wednesday, July 6, 2005, 3:25:37 PM, you wrote:

AM> Depending on the sittuation, IMHO, COUNT(*) wouldn't be the way to
AM> go. If you need the user's id or somesuch, you have to run an
AM> additional query to get the info.

But they're returning absolutely nothing in this case - which
(providing username was indexed) would make count() a far quicker and
less expensive query than selecting and bring back data and then doing
absolutely nothing with it (somewhat pointless imho)

You can select just the id, and provided that the query returns just zero or one row, you can spare one function call.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux