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.