Re: [sqlite] sharing in memory db through threads

n...@mailinglists.sqlite.org](https://email.ionos.de/appsuite/mailto:)] > > On Behalf Of Wasilios Goutas > > >Sent: Monday, 5 November, 2018 08:28 > > >To: sqlite-users@mailinglists.sqlite.org > > >Subject: [sqlite] sharing in memory db through threads > >

Re: [sqlite] sharing in memory db through threads

On 5 Nov 2018, at 3:28pm, Wasilios Goutas wrote: > To speed up pre-processing and importing of data I would like to grand > several threads access to the same in memory database I did not look at your source code, but you may not get the results you want. Using many threads/processes to

Re: [sqlite] sharing in memory db through threads

> On Nov 5, 2018, at 7:28 AM, Wasilios Goutas wrote: > > To speed up pre-processing and importing of data I would like to grand > several threads access to the same in memory database That may not help. SQLite only supports a single writer, so only one connection can open a transaction at a

Re: [sqlite] sharing in memory db through threads

. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Wasilios Goutas >Sent: Monday, 5 November, 2018 08:28 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] sharing in memory db through threads > &

[sqlite] sharing in memory db through threads

Hi, I try to use an in memory database which works as long as I use as db path ":memory:". To speed up pre-processing and importing of data I would like to grand several threads access to the same in memory database and have found the documentation on https://www.sqlite.org/inmemorydb.html