On 2016/02/25 9:40 AM, Jim Wang wrote:
> hi,all
>       How could I modify the page_size of the Data base? I use the following 
> method, but could not change the page_size.
>        nRet = sqlite3_exec(m_pDB, "PRAGMA page_size=8192;", 0,0,&pzErrMsg);
>       Why?

Because the Pragma specifies the ideal, it doesn't make the change.

Follow that up with a "VACUUM;" to make the change and re-pack the DB file.



Reply via email to