Re: [sqlite] Sqlite Concurrent access issue

2011-12-22 Thread Kees Nuyt
On Thu, 22 Dec 2011 13:49:48 +, "Black, Michael (IS)" wrote: > You're probably seeing disk thrashing. > > Try increasing your database cache size: > > .pragma cache_size XX Make that PRAGMA cache_size=xx; > It's in kilobytes. Almost correct. Cache_size is in number of data

Re: [sqlite] Sqlite Concurrent access issue

2011-12-22 Thread Black, Michael (IS)
J (GE Energy) [chetan.virpa...@ge.com] Sent: Wednesday, December 21, 2011 10:35 PM To: sqlite-users@sqlite.org Cc: Kurien, Jessy S (GE Energy); Singh, Rituraj (GE Energy); R, Raghuraman (GE Energy) Subject: EXT :[sqlite] Sqlite Concurrent access issue Hi, We have been using SQLite database f

Re: [sqlite] Sqlite Concurrent access issue

2011-12-21 Thread Simon Slavin
On 22 Dec 2011, at 4:35am, Virparia, Chetan J (GE Energy) wrote: > Query : Select * from mytable where in ( around 0.2 million > comma separated values) Anything that requires handling .2 million things is going to be tricky. Optimizing this query would be done differently depending on what g

[sqlite] Sqlite Concurrent access issue

2011-12-21 Thread Virparia, Chetan J (GE Energy)
Hi, We have been using SQLite database for a while using single threaded WCF service for our condition based monitor solution. Since, we are facing issues related to scalability for our next generation products due to single threaded architecture, We have been working on using SQLite concurr