in reply to Batch INSERT performance
What database are you using? This is faster with MySQL, often by a significant margin. Even faster is LOAD DATA, but that requires some moderately annoying data formatting and error handling is harder (error ignoring is easy though!).
-sam
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Batch INSERT performance
by Herkum (Parson) on May 05, 2009 at 20:18 UTC | |
by roboticus (Chancellor) on May 05, 2009 at 21:06 UTC | |
by samtregar (Abbot) on May 07, 2009 at 15:25 UTC |
In Section
Seekers of Perl Wisdom