Subject Re: [firebird-support] number of tables in database
Author Thomas Steinmaurer
Hi Sean,

> I heard that, performance will degrade if there are more than a 1000
> tables in a database. Is that true? What's the recommended up limit of
> number of tables w/o affecting performance? I am using Firebird 1.5.

Not that I know of. You might be able to "stall" any database server
with just a bunch of tables easily, if you don't care about a good
logical and physical database design and the supported concepts
concerning locking strategies and such.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com