Subject Re: [firebird-support] number of tables in database
Author Martijn Tonies
> > 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.
> Where have you heard that???
> I have been following the Firebird/IB lists since 1994 and don't recall
> ever hearing of performance problems due simply to the number of tables
> in the database.

not entirely true, remember additional indices being added to the
system tables?

The metadata caching by Firebird itself would be slowish, but, this
is a one-time issue as long as the database stays connected.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!