Re^4: Mass inserts with SQLite + CSV + execute

in reply to Re^3: Mass inserts with SQLite + CSV + execute_array?
in thread Mass inserts with SQLite + CSV + execute_array?

AutoCommit is the opposite of being in a transaction. Quote DBI,

[begin_work] enables transactions (by turning AutoCommit off) until the next call to commit or rollback. After the next commit or rollback, AutoCommit will automatically be turned on again.

He should be using begin_work and commit, though. DBI might not check for do("BEGIN").

Comment on Re^4: Mass inserts with SQLite + CSV + execute_array? Select or Download Code

Replies are listed 'Best First'.
Re^5: Mass inserts with SQLite + CSV + execute_array? by Xenofur (Monk) on Dec 15, 2008 at 11:35 UTC
Didn't help much. Benchmarks: `begin+end 1: the code took:307 wallclock secs (109.22 usr + 35.47 sys = 144.69 CPU) begin+end 2: the code took:279 wallclock secs (107.95 usr + 37.08 sys = 145.03 CPU) begin_work+commit: the code took:297 wallclock secs (107.45 usr + 37.13 sys = 144.58 CPU)` [download]	[reply] [d/l]

Replies are listed 'Best First'.

Re^5: Mass inserts with SQLite + CSV + execute_array?
by Xenofur (Monk) on Dec 15, 2008 at 11:35 UTC

begin+end 1:
the code took:307 wallclock secs (109.22 usr + 35.47 sys = 144.69 CPU)

begin+end 2:
the code took:279 wallclock secs (107.95 usr + 37.08 sys = 145.03 CPU)

begin_work+commit:
the code took:297 wallclock secs (107.45 usr + 37.13 sys = 144.58 CPU)
[download]

[reply]
[d/l]

In Section Seekers of Perl Wisdom