-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of mrobi...@cs.fiu.edu Sent: Wednesday, March 18, 2009 7:26 PM To: sqlite-users@sqlite.org 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users