Re: [sqlite] Sqlite Concurrent access issue

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.

Re: [sqlite] Sqlite Concurrent access issue

You're probably seeing disk thrashing. Try increasing your database cache size: .pragma cache_size XX It's in kilobytes. Try and make it as big as your database if you can. In other words, cache the whole thing. Secondly, you may want to try using the FTS3/FTS4 search capability if

Re: [sqlite] Sqlite Concurrent access issue

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