Do you know where your variables are? | |
PerlMonks |
Re: Batch INSERT performanceby Jenda (Abbot) |
on May 05, 2009 at 23:47 UTC ( [id://762113]=note: print w/replies, xml ) | Need Help?? |
With most databases you'd get a nice performance boost by something as simple as turning the AutoCommit off and committing only once every N rows. (The N depends on a lot of things, the row size, the database server, the table size, ... you'd have to benchmark it.) I do doubt interpolating the values into the SQL is the right thing to do. Depends on the database. Jenda
In Section
Seekers of Perl Wisdom
|
|