AFAIK, WAL mode is used and database is not empty, VACUUM operation doesn't change page size.
But, I'm not sure about latest version of SQLite. :) 2016? 2? 25? (?) 16:50, R Smith <rsmith at rsweb.co.za>?? ??: > > > 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. > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >