Re: [sqlite] SQlite performance on multi process env

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) effeciently."

Re: [sqlite] SQlite performance on multi process env

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 be

Re: [sqlite] SQlite performance on multi process env

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. > Multiproces

Re: [sqlite] SQlite performance on multi process env

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. -- View this message in context: http:

Re: [sqlite] SQlite performance on multi process env

So yes the hard disk is shared. I tried to even load the database in memory. It is still horribly slow. I want to understand this. If I load the database in memory how can I make the memory sharable among 100 processes. I am running in quad core environement. So my goal here is to load the databa

Re: [sqlite] SQlite performance on multi process env

the hard disk is shared so it is a critical resource,as well as 100 processes doesn't seem realistic on a single processor, dual core or not. so I can understand your result, I find even them not too bad ... Cheers, Sylvain On Thu, May 28, 2009 at 12:38 AM, zhrahman wrote: > > I am doing a sim

[sqlite] SQlite performance on multi process env

I am doing a simple test on sqlite where in step one, I just write 10,000 records on a simple database having three fileds. In step 2, after the write is done, I want 100 process reading from the database and doing simple SQLs, no update on the databse just simple select read operations. I am get