Re: [sqlite] Why the parallel read of DB is faster with separate connections per thread?

See also https://www.sqlite.org/threadsafe.html > -Original Message- > From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users- > boun...@mailinglists.sqlite.org] On Behalf Of Yuri > Sent: Friday, 17 June, 2016 14:02 > To: SQLite mailing list > Subject: [sqlite] Why the

Re: [sqlite] Why the parallel read of DB is faster with separate connections per thread?

> I have a fairly large DB that I need to only read (not write) as fast as > possible. I open DB with flags > SQLITE_OPEN_READONLY|SQLITE_OPEN_PRIVATECACHE and then run select > queries in 8 threads. > > When each thread opens its own connection, DB is read in 8 wallclock > seconds using 23 user

[sqlite] Why the parallel read of DB is faster with separate connections per thread?

I have a fairly large DB that I need to only read (not write) as fast as possible. I open DB with flags SQLITE_OPEN_READONLY|SQLITE_OPEN_PRIVATECACHE and then run select queries in 8 threads. When each thread opens its own connection, DB is read in 8 wallclock seconds using 23 user seconds.