On Fri, Apr 22, 2016 at 05:53:06PM +0300, Alex Peshkoff wrote:
> On 04/22/2016 04:59 PM, Stefan Heymann wrote:
> > I just tested the new 3.0.0 Release (Build 32483) fbclient.dll against
> > a Firebird 2.5.5 database. It takes ages (about 1 second) to attach to
> > the database. Connection to a Firebird 3.0 database is quick as ever.
> >
> > Are there plans to speed this up? It's quite annoying.
>
> Stefan, I've made a test. It's dev-build therefore it's not too fast but
> look here:
>
> # time (echo 'exit;' | ./isql -z -user sysdba -pas masterkey
> localhost:employee)
> ISQL Version: LI-V2.5.6.26980 Firebird 2.5
> Server version:
> LI-V2.5.6.26980 Firebird 2.5
> LI-V2.5.6.26980 Firebird 2.5/tcp (localhost)/P12
> LI-V2.5.6.26980 Firebird 2.5/tcp (localhost)/P12
> exit;
> real 0m0.183s
>
> # time (echo 'exit;' | ./isql -z -user sysdba -pas masterkey
> localhost:employee)
> ISQL Version: LI-V3.0.0.32486-dev Firebird 3.0
> Server version:
> LI-V2.5.6.26980 Firebird 2.5
> LI-V2.5.6.26980 Firebird 2.5/tcp (localhost)/P12
> LI-V3.0.0.32486-dev Firebird 3.0/tcp (localhost)/P12
> exit;
> real 0m0.161s
>
> I do not notice 3.0 client to work slower.
I suspect the difference may be that on your system connect() to ::1
fails (almost) immediately while on Stefan's it has to wait for timeout
for some reason as if e.g. the SYN packet was dropped silently
(actually, on Linux, connect() would fail immediately even then, but
Windows networking stack may behave differently).
Michal Kubecek
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
