I am not able to persist the MAX_PAGE_COUNT on the database I am using.

OS : Windows
Version: 3_5_4 dated 14.Dec.2007

1) Create a database - say store01.sqlite
2) Open store01.sqlite using sqlite.exe
3) Execute "pragma MAX_PAGE_COUNT = 200000;"
4) Execute "pragma MAX_PAGE_COUNT;" --> returns 200000
5) Quit sqlite.exe
6) Reopen store01.sqlite using sqlite.exe
7) Execute "pragma MAX_PAGE_COUNT;" --> returns 1073741823 (default)!!

Why? How can I persist the MAX_PAGE_COUNT value so that the database size
remains what I want it to be?

Further, from sqlite3_analyzer output can I get the MAX_PAGE_COUNT value.


Reply via email to