[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)