Subject | Re: Delays connecting to a small database |
---|---|
Author | alex_vnru |
Post date | 2002-02-04T11:28:01Z |
--- In ib-support@y..., "Tobias Giesen" <tobias_subscriber@t...>
wrote:
speeds up first connect to database up to 20 times.
Best regards, Alexander V.Nevsky.
wrote:
> Jason:ten
> > 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
> 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.