Thanks Mark. Kind of found the same info, with no mention of an actual max number of tables. We know it could handle "large" databases, but thought there might somehow be a limit on number of tables. Our client simply raised the concern about the application being able to grow without "limit", based on the way were planning to design it.
steve > > >> Does anyone know if a mysql database has a maximum number of tables it > can >> handle? We are writing an application where the number of tables could > grow >> into several thousand. > >> From the MySQL website: > > Handles large databases. We use MySQL Server with databases that contain > 50 million records. We also know of users that use MySQL Server with > 60,000 tables and about 5,000,000,000 rows. > Up to 32 indexes per table are allowed. Each index may consist of 1 to > 16 columns or parts of columns. The maximum index width is 500 bytes > (this may be changed when compiling MySQL Server). An index may use a > prefix of a CHAR or VARCHAR field. > > Regards, > > Mark Groen > ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
