Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: speeding up row by row lookup in a large db

by merlyn (Sage)
on Mar 22, 2009 at 16:22 UTC ( [id://752403]=note: print w/replies, xml ) Need Help??


in reply to speeding up row by row lookup in a large db

If you have to fetch all million cells with individual selects, you're doing it wrong. Either pull out a million row result in one query, or push more of your data reduction to the database using stored procedures.
  • Comment on Re: speeding up row by row lookup in a large db

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others imbibing at the Monastery: (4)
As of 2024-04-25 17:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found