Subject Re: Delays connecting to a small database
Author alex_vnru
--- In ib-support@y..., "Tobias Giesen" <tobias_subscriber@t...>
wrote:
> Jason:
> > The first connection to a database (i.e. 0 users ->
> > 1 user), certainly takes a lot longer then subsequent ones.
> > Is this likely to be the case, if so you may want to employ
> > an application that just connects to databases and does
> > nothing.
>
> Hmm ... that must be it ... I guess I'll have to keep track of the
ten
> or twenty most used databases and do what you say. Thanks!


Tobias, for me additional index by RDB$FOREIGN_KEY on RDB$INDICES
speeds up first connect to database up to 20 times.

Best regards, Alexander V.Nevsky.