Re: [sqlite] Difference between SQLITE_CONFIG_MULTITHREAD & SQLITE_CONFIG_SERIALIZED options

2012-02-14 Thread Pavel Ivanov
When you use SQLITE_CONFIG_MULTITHREAD you can't use the same handle in different threads without some sort of synchronization. With SQLITE_CONFIG_SERIALIZED you can do that because SQLite will do synchronization for you. So there's no difference in concurrency here. If you use different handles

[sqlite] Difference between SQLITE_CONFIG_MULTITHREAD & SQLITE_CONFIG_SERIALIZED options

2012-02-13 Thread Rittick Gupta
What is the difference between the SQLITE_CONFIG_MULTITHREAD & SQLITE_CONFIG_SERIALIZED options - When a) the same handle is shared between multiple threads in a process and when different handles are used by threads in a proceses. Is there any difference in concurrency ? What should be used