On 03/23/2012 01:19 AM, Jeff Robbins wrote:
Item 12 on the limits page (http://www.sqlite.org/limits.html) states
that a maximum SQLite database size is about 140 terabytes. But item
13 on the same page refers to 14 terabytes as the maximum.
The calculation given in item 12 yields this value:
2147483646 * 65536 = 140,737,488,224,256
I don't see a calculation supporting item 13's maximum of 14
terabytes, so perhaps the two references to "14" in item 13 are a
typo? Or perhaps they refer to another actual limit? In either
case, the seeming contradiction is confusing.
I'd say the 14 is a typo.
The point of the statement in item 14 is that an SQLite database
may be at most 2^47 bytes in size. And since each row is at least
one byte, it is not possible to test the theoretical 2^64 row
limit.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
