On 19/04/2009 4:42 PM, Eugene Wee wrote: > Hi, > > On Sun, Apr 19, 2009 at 12:41 PM, Randomcoder <randomcod...@gmail.com> wrote: >> Is there a maximum rows limit imposed on tables in sqlite ? >> I could not find this information anywhere on www.sqlite.org so that's >> why I'm asking here. > > Referring to "Limits In SQLite": > http://www.sqlite.org/limits.html > It looks like the limit is more on database page size and number of > pages in the database file.
The number of rows in a table is "limited" by the row-id being stored in a signed 64-bit integer; presumably negative row-ids are not used, so that's 9,223,372,036,854,775,807 rows. Should be enough :-) Cheers, John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
