Re: Maximum number of tables?

On 14 Jun 97 at 20:32, Mike Rozenblyum wrote: > 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? Purely from a DBA's point of view, there is no way you could sensibly maintain 1000000+ tables. Programmers would also be swamped. I think you might be looking at the problem from the wrong end... $0.02 -- Ciao, Billy Nose to the ground and ear to the grindstone in: Kuwait 49 Degrees Celsius and climbing