[sqlite] How to persist MAX_PAGE_COUNT?

[Yuvaraj Athur Raghuvir]

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?

[Yuvaraj Athur Raghuvir]

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)