Re: [sqlite] How to do PRAGMA in C-interface?

Hi, On Thu, Jul 14, 2016 at 8:05 AM, Richard Hipp wrote: > On 7/14/16, wu tao 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

Re: [sqlite] How to do PRAGMA in C-interface?

On 7/14/16, wu tao 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 >

[sqlite] How to do PRAGMA in C-interface?

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