Posted by Angelo Zanetti on 07/06/05 17:20

have to agree with Richard here, its wasting resources bringing back *
from the database. Its one of those fundamentals. Only do a select *
from... where you actually need all the info.

Bill, try read the manual to see how the |mysql_query() returns info.
SOmeone has posted the link in this thread!
|

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)
>
>Best regards,
>
>Richard Davey
>
>

• Next in forum: Re: [PHP] IBM's Learning PHP Part 1 tutorial.
• Prev in forum: Re: [PHP] IBM's Learning PHP Part 1 tutorial.
• Thread view: Re: [PHP] IBM's Learning PHP Part 1 tutorial.

[Reply to this message]