laziness, impatience, and hubris | |
PerlMonks |
Re^3: DBI limitation???by derby (Abbot) |
on Apr 06, 2016 at 16:58 UTC ( [id://1159741]=note: print w/replies, xml ) | Need Help?? |
Gotcha. Well ... instead of a $dbh->do(...) ... which would read all the rows into memory before returning, I'd try the prepare/execute/fetchrow approach and hope the underlying DBD/OCI does the right thing memory wise.
-derby
Update: Doh! just reread this and saw it was a create statement, not a select. In that case I'm guessing you're timing out somewhere. You may want to look into using DBI->trace to try and track that down.
In Section
Seekers of Perl Wisdom
|
|