Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

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:

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (9)
As of 2016-10-24 08:15 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (303 votes). Check out past polls.