|Think about Loose Coupling|
Re^4: Threads and DBD::SQLite?by erix (Vicar)
|on Dec 16, 2013 at 00:39 UTC||Need Help??|
UPDATE: numbers are partly wrong; see further discussion lower down in this thread
I experimented a bit with this, on Centos 6.5. I had only a threaded perl 5.19.7 handy.
Initially I got similar (disappointing) results, but then I found two problems with the test program:
1. It turns out that after the "Create primary index"; block, a $dbh->commit is needed to get the index to be used/committed.
2. A (much) higher rowcount $N gives more interesting results. From around N$ = 10_000 and upwards, the threaded version *is* (much) faster.
For instance, for rowcount $N = 100_000:
So, it was a good approach after all.