I don't know if you do this (haven't looked for your source or anything), but Shawn319 mentioning SELECT * reminded me to mention this.
SELECT * requires your RDBMS to make two lookups to the table and can triple the load on the server and the time it takes to execute the query. In addition to that, it often brings back columns you simply don't need.
Happy Hacking,
Lord Daeken M. BlackBlade
(Cody Brocious)
|