[thelist] MySQL oddness

Henry Wong hwong at dja.com
Tue Jan 29 10:04:34 CST 2008


I would list out every column anyways,

just in case the DBA added in extra columns later (such as text)
and might slow down the query.

On Jan 29, 2008, at 10:46 AM, Jeremy Weiss wrote:

> Quick question:
>> BTW, rule #1 of writing decent SQL: Never use SELECT *
>> This causes MySQL to first do a look up on all the columns of the  
>> table,
>> before then using them in the SELECT statement. When you specify the
>> columns, you firstly reduce the time it takes to execute the query  
>> and the
>> load on the MySQL server, and secondly you narrow the data down to  
>> only
>> that which you really need.
> Does this rule apply even if you do need every column in a table?
> -jeremy
> -- 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !

More information about the thelist mailing list