Re: [sqlite] 1TB limit on encrypted database

2017-11-17 Thread David Raymond
-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Wednesday, November 15, 2017 7:18 AM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] 1TB limit on encrypted database On 11/15/17, Andrew Stewart

Re: [sqlite] 1TB limit on encrypted database

2017-11-17 Thread Andrew Stewart
-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Wednesday, November 15, 2017 7:18 AM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] 1TB limit on encrypted database On 11/15/17, Andrew Stewart <astew...@arguscon

Re: [sqlite] 1TB limit on encrypted database

2017-11-15 Thread Richard Hipp
On 11/15/17, Andrew Stewart wrote: > Thanks. This has worked. Temporarily. You cannot increase the max_page_count above 2147483646, so if your database continues to grow, you are going to need to look into increasing the page size from 1024 to something larger like

Re: [sqlite] 1TB limit on encrypted database

2017-11-15 Thread Andrew Stewart
ers@mailinglists.sqlite.org> Subject: Re: [sqlite] 1TB limit on encrypted database On 11/14/17, Andrew Stewart <astew...@arguscontrols.com> wrote: > 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

Re: [sqlite] 1TB limit on encrypted database

2017-11-14 Thread Richard Hipp
On 11/14/17, Andrew Stewart wrote: > 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

Re: [sqlite] 1TB limit on encrypted database

2017-11-14 Thread Andrew Stewart
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 enc

Re: [sqlite] 1TB limit on encrypted database

2017-11-14 Thread Richard Hipp
On 11/14/17, Andrew Stewart 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

[sqlite] 1TB limit on encrypted database

2017-11-14 Thread Andrew Stewart
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. Andrew Stewart Argus Control Systems