Richard,
If I am trying to change the max_page_count use the SEE.EXE program,
how do I get the value to be updated in the database. Every time I try
changing this and then exit see.exe, the value has not changed. Do I need the
updated encryption extension first?
Andrew Stewart
Argus Control Systems Ltd.
-----Original Message-----
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Richard Hipp
Sent: Tuesday, November 14, 2017 11:33 AM
To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
Subject: Re: [sqlite] 1TB limit on encrypted database
On 11/14/17, Andrew Stewart <astew...@arguscontrols.com> wrote:
> Hi,
> I appear to have reached an issue with a 1TB limit on
> an encrypted database. The page_size is 1024. The max_page_count is
> 1073741823. I don't appear to be able to change either of these numbers.
> Any assistance would be appreciated.
You can try:
PRAGMA max_page_count=2000000000;
Probably you should also look into increasing the page size:
PRAGMA page_size=8192;
VACUUM;
For that last step, make sure you have upgraded to a recent version of the
encryption extension as some of the older versions had issues.
Also, note that the VACUUM will take some time and will require a couple TB of
temporary disk space while it is running.
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Notice: This electronic transmission contains confidential information,
intended only for the person(s) named above. If you are not the intended
recipient, you are hereby notified that any disclosure, copying, distribution,
or any other use of this email is strictly prohibited. If you have received
this transmission by error, please notify us immediately by return email and
destroy the original transmission immediately and all copies thereof.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
