in reply to DBI/mysql gathering all rows on execute
If the execute is taking a long time, I would suggest putting something like a LIMIT ?, OFFSET ? at the end of your query, insert useful values into the appropriate placeholders (shudder) and use that approach to break the query up into bite-sized chunks. That should limit memory consumption.
--t. alexLife is short: get busy!
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Re: DBI/mysql gathering all rows on execute
by jdtoronto (Prior) on Nov 24, 2003 at 20:33 UTC |
In Section
Seekers of Perl Wisdom