[sqlite] How to persist MAX_PAGE_COUNT?
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 = 20;" 4) Execute "pragma MAX_PAGE_COUNT;" --> returns 20 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
[sqlite] How to persist MAX_PAGE_COUNT?
Hello, When I set the MAX_PAGE_COUNT and retrieve the value in the same connection, I get what I set. However, when I use a new connection to the database, I get the default value. Also if I close all connections and restart, I am getting the default value. Statements used: PRAGMA MAX_PAGE_COUNT =100; PRAGMA MAX_PAGE_COUNT; Am I missing something? Regards, Yuva sqlite3.dll dated 14.Dec.2007 (3_5_4)