Welcome to the Monastery | |
PerlMonks |
Re: speeding up row by row lookup in a large dbby merlyn (Sage) |
on Mar 22, 2009 at 16:22 UTC ( [id://752403]=note: print w/replies, xml ) | Need Help?? |
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.
In Section
Seekers of Perl Wisdom
|
|