sqlite3 write,read queries are pathetically slow

Previous Topic Next Topic
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

sqlite3 write,read queries are pathetically slow

This post has NOT been accepted by the mailing list yet.
Hello All,

we have recently moved to plain vanilla sqlite3 from sql anywhere database.
In our application, we use sqlite db to maintain client side meta data
information. The db instance can be used by one client installation only.
we are noticing huge performance impact wrt DB calls. As we keep writing
into the DB, the operations become hopelessly slow though the DB file does
not grow beyond 10 MB or so.

Our code connects to DB via ADO layer and use to work well with SQL
Anywhere. After a threshold, all read and write operations become expensive.

we have tried with following PRAGMA options but to minimum effect:

Please suggest.