Hi, On Thu, Jul 14, 2016 at 8:05 AM, Richard Hipp <[email protected]> wrote: > 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.
Can you try setting it one-by-one and not as one command? Thank you. > > 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 _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
