Thanks for the Reply..
"Internally SQLite uses locks to serialize calls by multiple threads."
if this is case then how can we achieve concurrency?
we are using 50 threads and 1500 time it is called for 30min. At
initial stage it works fine at some point of time the performance degrades.
Is there any way to achieve maximum concurrency? Please suggest...
On Wed, Sep 6, 2017 at 8:53 PM, Jens Alfke <j...@mooseyard.com> wrote:
> > On Sep 4, 2017, at 7:22 AM, Senthil Kumar Chellappan
> <senthilkumar.chellap...@gmail.com> wrote:
> > I am using only select operation ,but it gets degreaded(response time)
> > i calls the API thur multi threading
> Internally SQLite uses locks to serialize calls by multiple threads. If
> multiple threads are trying to access it at once, that will increase
> overhead since the locks have to control the access. Usually this isn't
> noticeable since the overhead for acquiring a single lock is very low, but
> it depends on how many calls are being made.
> You'll need to give more details of what calls you're making, on how many
> threads, and how many times they're called.
> sqlite-users mailing list
sqlite-users mailing list