Writes are slow if you do one insert per transaction.
http://search.cpan.org/perldoc?DBD::SQLite#Performance
Owen wrote:
I have a sqlite (version 3.6.13) database with 30+ rows
1500 of these rows have faulty data.
So I read the main database row by row, tested the validity of one
column,
I have a sqlite (version 3.6.13) database with 30+ rows
1500 of these rows have faulty data.
So I read the main database row by row, tested the validity of one
column, and inserted the good rows into a new database.
This process took 27 minutes on a fairly recent desktop computer.
( about 1