Re: [sqlite] Shared in-memory SQLite database in shared memory

2012-11-03 Thread Howard Chu
Jaco Breitenbach wrote: Dear all, My application consists of several indepent processes that must all access (read) the same data table during processing. In order to optimise memory usage I was wondering if it is possible to load an in-memory SQLite database into shared memory. The database w

Re: [sqlite] Shared in-memory SQLite database in shared memory

2012-11-03 Thread Simon Slavin
On 3 Nov 2012, at 3:26pm, Jaco Breitenbach wrote: > In my application I have multiple separate processes, not threads. Sorry, I missed that. You would seem to need some sort of sharing memory between your processes. Don't know how to do that. Simon. _

Re: [sqlite] Shared in-memory SQLite database in shared memory

2012-11-03 Thread Roger Andersson
On 11/03/12 16:26, Jaco Breitenbach wrote: I wanted to have the database in shared memory. Maybe a ram drive? What operating system are you running? Cheers Roger ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mail

Re: [sqlite] Shared in-memory SQLite database in shared memory

2012-11-03 Thread Jaco Breitenbach
Hi Simon, In my application I have multiple separate processes, not threads. I believe the shared cache doesn't work across processes. I essentially want a single shared read-only database that can be accessed at high speed. Since the data set can become quite large and with multiple processes

Re: [sqlite] Shared in-memory SQLite database in shared memory

2012-11-03 Thread Simon Slavin
On 3 Nov 2012, at 12:26pm, Jaco Breitenbach wrote: > My application consists of several indepent processes that must all access > (read) the same data table during processing. In order to optimise memory > usage I was wondering if it is possible to load an in-memory SQLite > database into share