Re: [sqlite] Serialized access faster than multithreaded?

2012-05-03 Thread Simon Slavin
On 3 May 2012, at 10:30pm, Igor Tandetnik wrote: > On 5/3/2012 5:04 PM, Marco Era wrote: >> Now that I have some time, I'm stress testing it to see how much I can get >> from it; what I want to check is its performance in a multithreading >> environment. >> >> To my

Re: [sqlite] Serialized access faster than multithreaded?

2012-05-03 Thread Pavel Ivanov
> Serialized test (SQLITE_THREADSAFE=1): > > The main thread opens the database, sets the cache and busy timeout to huge > values and passes the db descriptor to the threads. > > Multithreaded test (SQLITE_THREADSAFE=2): > The main thread creates the other threads and wait; each thread opens its

Re: [sqlite] Serialized access faster than multithreaded?

2012-05-03 Thread Igor Tandetnik
On 5/3/2012 5:04 PM, Marco Era wrote: Now that I have some time, I'm stress testing it to see how much I can get from it; what I want to check is its performance in a multithreading environment. To my surprise, it seems that serialized access to the database (which is the default in the

[sqlite] Serialized access faster than multithreaded?

2012-05-03 Thread Marco Era
Hi there, I've been using sqlite for a few years now and it worked fine in my experience. Now that I have some time, I'm stress testing it to see how much I can get from it; what I want to check is its performance in a multithreading environment. To my surprise, it seems that serialized access