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

Reply via email to