Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
I couldn't agree with Ovid more. Using 'SELECT *' is not just about column alignment mismatch issues. When you 'SELECT *' on a 500 column table, all the columns are loaded, even if you only use 1 or 2. This can be a lot of data exchange if your DB resides on a remote server.
Generally, you have an idea as to what you are asking for, or at least, what the application of your select will be. Even if you are using the hashref methods, less data loaded means faster transactions. The "Moral"? Just because you can make 'SELECT *' safe to use does not make it the right thing to do. As they say: Just because you can doesn't mean you should. In reply to Re: Module Pondering
by tadman
|
|