> > 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
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com