[sqlite] Improving performance of my windows service using SQLite DB to save settings

On Thu, 21 Jan 2016 22:21:31 +0530 Deepak wrote: > How can improve the service performance here? Keeping in mind, > > >- There will be no new inserts (ignoring addition of few hundred > URLs once a day while overwriting the older ones). Size of the DB > will be more or less constant in rang

[sqlite] Improving performance of my windows service using SQLite DB to save settings

Dear SQLite Community, Please help me with your expertise and advice. Environment: - Windows service which reads/updates any one of 60 different settings (integer values and strings) stored in SQLite database. This is .db file on disk. Another windows service (over which I have not cont

[sqlite] Improving performance of my windows service using SQLite DB to save settings

On 21 Jan 2016, at 4:51pm, Deepak wrote: > The transaction finishes in 1-3 seconds Do you have indexes on the tables which make the most frequent operations run quickly ? Simon.