Re: [sqlite] SQlite performance on multi process env

2009-05-28 Thread Griggs, Donald
Subject: Re: [sqlite] SQlite performance on multi process env Hello, Zhrahman, Regarding: "... kindly suggest how to properly have the database shared in memory among n number of processes. So they can execute select operatins(read only no update on teh database) effeci

Re: [sqlite] SQlite performance on multi process env

2009-05-28 Thread Jay A. Kreibich
On Thu, May 28, 2009 at 10:53:34AM -0700, zhrahman scratched on the wall: > > Few other info > I am running it on Linux. So to make the long story short, kindly suggest > how to properly have the database shared in memory among n number of > processes. You can't. ":memory:" databases cannot

Re: [sqlite] SQlite performance on multi process env

2009-05-28 Thread John Elrick
zhrahman wrote: > Few other info > I am running it on Linux. So to make the long story short, kindly suggest > how to properly have the database shared in memory among n number of > processes. So they can execute select operatins(read only no update on teh > database) effeciently. >

Re: [sqlite] SQlite performance on multi process env

2009-05-28 Thread zhrahman
://www.nabble.com/SQlite-performance-on-multi-process-env-tp23752056p23766728.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQlite performance on multi process env

2009-05-28 Thread zhrahman
. I hope some shared memory approach is used here. But what I see is unless I recreate all the tables individually for each process the memory sharing doesnt happen. Please help me out here -- View this message in context: http://www.nabble.com/SQlite-performance-on-multi-process-env

Re: [sqlite] SQlite performance on multi process env

2009-05-28 Thread Sylvain Pointeau
second > -- > View this message in context: > http://www.nabble.com/SQlite-performance-on-multi-process-env-tp23752056p23752056.html > Sent from the SQLite mailing list archive at Nabble.com. > > ___ > sqlite-users mailing list >

[sqlite] SQlite performance on multi process env

2009-05-27 Thread zhrahman
-on-multi-process-env-tp23752056p23752056.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users