No such thing as a small change | |
PerlMonks |
Re: DBI vs Bulk Loadingby LanceDeeply (Chaplain) |
on Sep 14, 2005 at 22:03 UTC ( [id://492050]=note: print w/replies, xml ) | Need Help?? |
how much of your process is updating records vs inserting new records? if it's mostly updates: if it's mostly inserting new records: i dont kow what kind of volume you are processing, but if the full table is too much for your process to handle, you can slice it up by day/hour. -HTH
In Section
Seekers of Perl Wisdom
|
|