On 7/14/16, wu tao <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
