in reply to Sqlite: Threads and inserts into a different database for each one. (1 thread fast, >1 slow)

Sounds about right. Well done. You produced pretty much exactly the results I would expect from looking at the code you've posted.

(Had that code be complete, I might have tried running it, but....)

With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.
  • Comment on Re: Sqlite: Threads and inserts into a different database for each one. (1 thread fast, >1 slow)

In Section Seekers of Perl Wisdom