in reply to Mass inserts with SQLite + CSV + execute_array?

Just out of sheer curiosity, what was the speed-up between the original "single inserts" and the "mass inserts"?

CountZero

A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

  • Comment on Re: Mass inserts with SQLite + CSV + execute_array?

Replies are listed 'Best First'.
Re^2: Mass inserts with SQLite + CSV + execute_array?
by Xenofur (Monk) on Dec 14, 2008 at 19:15 UTC
    I didn't do any serious benchmarking, so i don't know if the execute_array thing did any good. It didn't do any noticeable good, so i reverted to the form above.

    I can however say, that using the BEGIN;END; pair gave at least 10 times more speed, but i think that's mostly a SQLite thing.
[reply]

In Section Seekers of Perl Wisdom