-------- Original message -------- From: Stephan Beal <sgb...@googlemail.com> Date: 01/03/2016 12:07 (GMT+00:00) To: SQLite mailing list <sqlite-users at mailinglists.sqlite.org> Subject: Re: [sqlite] Random-access sequences
> On Tue, Mar 1, 2016 at 12:59 PM, Matthias-Christian Ott <ott at mirix.org> wrote: >> Unfortunately, this limits the maximum number of elements that can ever >> be inserted during a table's life-time to 2^63 - 1. While this might be >> acceptable in some cases it is an artificial limitation. >> >Artificial, yes, but so is "64 bits." You will likely hit other limitations far before getting anywhere near 2^63-1 insertions: > https://www.sqlite.org/limits.html > e.g. point #13: > *Maximum Number Of Rows In A Table* I don't think he's bothered about the maximum number of rows at one time, but that he might run out of new rowids. However, this feels as needless a concern: with 1,000 queue/dequeues per second, 2^63 IDs will last 292 million years...? Graham.
