It's great it's not a problem at all for firebird 1.5.
Thank you all!

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

>
> > > 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
>