|Subject||Re: [firebird-support] number of tables in database|
> > I heard that, performance will degrade if there are more than a 1000not entirely true, remember additional indices being added to the
> > 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.
The metadata caching by Firebird itself would be slowish, but, this
is a one-time issue as long as the database stays connected.
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!