Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: For a better efficiency and speed question!

by Anonymous Monk
on Oct 05, 2011 at 08:40 UTC ( #929736=note: print w/ replies, xml ) Need Help??


in reply to For a better efficiency and speed question!

How many rows does that query operate on? How many are returned? How long does the query alone take on the command-line interface?

If there are a lot of rows returned, you should look into fetching the rows sequentially (with DBI's fetchrow_hashref) instead of fetching the whole resultset into an arrayref.

You might find the following presentation of much help: http://www.cpan.org/authors/id/TIMB/DBI_AdvancedTalk_200708.pdf


Comment on Re: For a better efficiency and speed question!
Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (6)
As of 2015-07-30 05:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (270 votes), past polls