On 7/14/16, wu tao <wrena...@gmail.com> wrote: > I tried to do the sqlite db PRAGMA via c-interface, sqlite3_exec() with the > following statements, > > PRAGMA main.cache_size=5000;PRAGMA main.page_size = 2048;PRAGMA > main.locking_mode=NORMAL ;PRAGMA main.synchronous=NORMAL;PRAGMA > main.journal_mode=wal; > > Looks some PRAGMA are set, cache_size setting does not work after > sqlite3_exec() returned.
That should work fine. I do not know why you are having trouble. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users