Hello, 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. Thanks, Yuva