Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: DBI AoArefs dereference

by pajout (Curate)
on Jun 14, 2010 at 07:46 UTC ( #844537=note: print w/ replies, xml ) Need Help??


in reply to DBI AoArefs dereference

If you can change sql query, add "LIMIT = 10" clause (it is, in my opinion, best for performance), otherwise you can use

my $AoA = $dbh->selectall_arrayref($sql, {MaxRows=>10}, @sqlparams);


Comment on Re: DBI AoArefs dereference
Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (9)
As of 2014-10-01 21:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    What is your favourite meta-syntactic variable name?














    Results (40 votes), past polls