On Fri, May 30, 2008 at 07:40:13AM -0700, Ken scratched on the wall: > Hildemaro Carrasquel <[EMAIL PROTECTED]> wrote: > > > > How many rows can i insert in one table? > I'm not 100% sure but I think the answer is: > > 1,844,674,407,370,9551,615 > > which is an unsigned int (64bit).
RowIDs are signed, and every row needs a RowID. From <http://www.sqlite.org/autoinc.html>: ...the largest ROWID is equal to the largest possible integer (9223372036854775807 in SQLite version 3.0.0 and later)... -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "'People who live in bamboo houses should not throw pandas.' Jesus said that." - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
