On Fri, 3 Nov 2017 21:40:52 +0000 Simon Slavin <[email protected]> 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; INSERT ... INSERT ... COMMIT; Also, I don't really know how to set up a cache. I open my database as follows: sqlite3_open_v2(sdmd->sqlite_fn, &sdmd->db, SQLITE_OPEN_READWRITE | SQLITE_OPEN_PRIVATECACHE, NULL); Despite the privatecache, I experience that evry INSERT is written to the disk when I call sqlite3_finalize(). Thank you very much for your help. Levente _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
