> 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) when > 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. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users