[sqlite] Parallel access to read only in memory database

2016-10-07 Thread Daniel Meyer
We are interested in using sqlite as a read only, in memory, parallel access database. We have database files that are on the order of 100GB that we are loading into memory. We have found great performance when reading from a single thread. We need to scale up to have many parallel reader thread

Re: [sqlite] Parallel access to read only in memory database

2016-10-13 Thread Daniel Meyer
the list at > sqlite-users-ow...@mailinglists.sqlite.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of sqlite-users digest..." > > > Today's Topics: > >1. Parallel access to read only in memory datab

Re: [sqlite] Is it possible to connect to an in-memory sqlite

2016-11-14 Thread Daniel Meyer
I am very interested in the answer to this question. Currently it seems like the only way to get multiple connection to the in-memory db is with 'cache=shared' and I understand that subsequent connections opened to that memory database are Read/Write regardless of whether the new connections are o