Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://929736]
help
Chatterbox?
[Your Mother]: Stick with what you know. Or post a SOPW and if it's not complicated I guarantee someone will answer; me if it's straightforward and no one else gets it better first.
[1nickt]: ++YourMother (Grammar Vigilante of Bristol)
[Lady_Aleena]: Um, how does grep do multiline? print "$file:$_" if grep { /get_(array|hash| data)\(.+\)/ } $_; only returns the same 18 lines the command line grep does.
[Lady_Aleena]: my scratchpad has what I have so far.
[choroba]: what do you mean by multiline?
[Discipulus]: thanks 1nickt!
[choroba]: grep is a filter, it selects elements from a list based on a boolean condition
[moritz]: you need to read the file in one go to do a multiline regex match
[erix]: ha ha, I like the Vigilante
[Lady_Aleena]: Forget it. I'm getting angry with it.

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (12)
As of 2017-05-23 19:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?