Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: Memory usage with DBI

by guidomortonski (Sexton)
on Oct 11, 2001 at 15:25 UTC ( #118192=note: print w/ replies, xml ) Need Help??


in reply to Memory usage with DBI

A someone else noted, select * is a bad idea. Even if you *want* all the fields in the table, it's better form (and easier to manage in the long run) if you name the fields you want to select. If you don't and someone changes the table then all of a sudden your array is out of whack and everything breaks. Same goes for inserts.

If performance and speed are not as big an issue as nice, readable code you could also consider using fetchrow_hashref to fetch your data items as a hash of field name/value pairs.

Guy


Comment on Re: Memory usage with DBI

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://118192]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (3)
As of 2014-09-20 00:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (151 votes), past polls