On Fri, 3 Nov 2017 21:40:52 +0000
Simon Slavin <slavins-drl2ohjjk6tg9huczpv...@public.gmane.org> 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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to