Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: Re: Re: select * and bind_cols considered harmful

by perrin (Chancellor)
on Nov 22, 2002 at 19:18 UTC ( [id://215231] : note . print w/replies, xml ) Need Help??


in reply to Re: Re: select * and bind_cols considered harmful
in thread Perl Programming guidelines/rules

Easy, it's nothing personal. Select * with fetchrow_hashref will break in confusing ways if a column name is changed, but will survive columns being added. Of course performance will get progressively worse as columns get added even if they aren't being used. Regardless, select * is obviously a bad practice and fetchrow_hashref is just a band-aid that hides some of the badness. The DBAs at most jobs I've had would have hung me from the rafters if I used select * in production code.