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* The theoretical maximum number of rows in a table is 264 (18446744073709551616 or about 1.8e+19). This limit is unreachable since the maximum database size of 140 terabytes will be reached first. A 140 terabytes database can hold no more than approximately 1e+13 rows, and then only if there are no indices and if each row contains very little data. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
