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.

What is your server doing at the time? Is the CPU 100%.


BTW highly unlikely to be sweeps.

If there are certain clients that seem to be slower than others, you want to
check the environment, we have had slow responses from DNS / WINS servers on
certain clients and often resort to filling in the HOSTS file with the
servers.

Hope it helps.


JAC

> using Firebird RC2, I experience great differences in timing when
> connecting to small databases (<10MB). The problem is, my system uses
> several small databases rather than one big one, and the user needs to
> be able to switch between them quickly. Sometimes this takes a fraction
> of a second, sometimes very long (>15 secs). Can this have anything to
> do with database sweeps? What else can I do?
>
> Thanks.
>
> Tobias Giesen
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>