[Tickets #6198] Re: One loop less

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://dev.horde.org/horde/whups/ticket/?id=6198
-----------------------------------------------------------------------
 Ticket             | 6198
 Updated By         | Jan Schneider <jan at horde.org>
 Summary            | One loop less
 Queue              | Ansel
 Type               | Enhancement
 State              | Feedback
 Priority           | 1. Low
 Milestone          | 
 Patch              | 
 Owners             | Michael Rubinsky
-----------------------------------------------------------------------


Jan Schneider <jan at horde.org> (2008-02-04 14:06) wrote:

>> - Don't use SELECT *
>
> What's the rationale for this? In this case we actually do want all 
> the columns. Is there a performance issue with '*' vs putting all the 
> column names in the query explicitly?

If not a performance gain, this is a least good practice. And I'm pretty
sure this *is* a performance difference, at least on some RDBMs.