Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: Get a hash object from a database with DBI for use with HTML::Template

by dug (Chaplain)
on Aug 04, 2002 at 23:19 UTC ( #187550=note: print w/replies, xml ) Need Help??


in reply to Get a hash object from a database with DBI for use with HTML::Template

  Warning: this reads the entire data set into memory, so be careful not to read huge amounts of data.

You can avoid this by creating other problems :)
Inside of get_hash(),
my $sth = $dbhandle->prepare( $stmt );
can become
my $sth = $dbhandle->prepare( $stmt, {"mysql_use_result" => 1} );
This will block other processes, and you will need to roll throught the complete dataset with fetchall_* or fetchrow_* and friends to avoid future errors on the handle unless you want to set up a brand new database for each query. It does seem to make sense some places, however.

  dug

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (3)
As of 2022-01-20 16:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:












    Results (57 votes). Check out past polls.

    Notices?