Re: Maximum number of tables?

Mike Rozenblyum wrote: > > Hello! > > I am faced with a database design dilemma. According to my > most optimized design I would require a huge amount (1 million+) > of tables. My question is: is it acceptable to have a large > number of tables? And how well will the database handle this? > > Thank you VERY much in advance for your time. > > P.S. Please specify the database you are talking about. Thanks. Uhmm, Go back to school. What are you trying to map in to a database which would require 1 Million + tables? How is the data normalized? The type of database doesn't matter. Good normalization of data is database independant. -Mikey