[sqlite] memory leak

I'm fighting with some memory leak. From time to time the vsize of the process goes up with 100k. I have several function like this, and I call them in each second. My memory growth happens every 10 minutes or so. int dbSqliteSelectSensorsToReport(sdmd_t *sdmd, sensor_t *sensor, int deviceType,

Re: [sqlite] DB on JFFS

On 4 Nov 2017, at 4:29pm, Lev wrote: > That is a good idea, thanks. So it might look like this? > > BEGIN TRANSACTION; > > INSERT ... > INSERT ... > > COMMIT; Yes. > Also, I don't really know how to set up a cache. Don;’t bother with that at the moment. Simon.

Re: [sqlite] DB on JFFS

On Fri, 3 Nov 2017 21:40:52 + Simon Slavin wrote: > Those two are in conclict. You might like to try putting BEGIN … END > around your inserts just for testing. That is a good idea, thanks. So it might look like this? BEGIN TRANSACTION;