Re: DBI/mysql gathering all rows on execute


XP is just a number
	PerlMonks

Re: DBI/mysql gathering all rows on execute

by talexb (Chancellor)

on Nov 24, 2003 at 20:12 UTC ( #309662=note: print w/replies, xml )

Need Help??

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. alex
Life is short: get busy!