-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, March 18, 2009 7:26 PM To: [email protected] Subject: [sqlite] how many tables can I have in one database
Dear colleagues, I understand that Sqlite can handle databases with 2 teragytes of data each. I would like to know how many tables can a dabase have. Thank you Michael ========================================= Hi, Michael, I *think* the answer will be, "As many as you need." On the other hand, if you're contemplating a design involving hundreds of tables, then many would say that the design would likely benefit from some serious consideration as to normalization. Approximately how many tables do you envision using? There *is* a limit of 64 tables in one JOIN statement, by the way. http://www.sqlite.org/limits.html Regards, Donald _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
