Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Michal Kubecek]

On Wed, May 04, 2016 at 04:01:10PM +0200, Stefan Heymann wrote:
> > Ok, that did the trick. I can now also confirm that connecting to a
> > Firebird 2.5 server is quick when IPv6 is inactive on localhost.
> 
> Now that the technical reasons for this one-second delay are
> clarified: is there something that can/will be done to improve the
> situation? Do I need to open a ticket?

As discussed, the problem is in the configuration of the system in
question so that's where a proper solution.

I have a patch allowing "inet4" and "inet6" protocols in URL-like
connection strings to restrict host lookup to IPv4 or IPv6 addresses as
a workaround on systems where the issue cannot be fixed properly. The
patch is at

  https://github.com/mkubecek/firebird/commits/mk/4.0/inet46

I would like to run few more tests and then I'll create a pull request
(tomorrow, hopefully). I believe it can be also cherry picked into
B3_0_Release branch if there are no objections.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Stefan Heymann]

> Ok, that did the trick. I can now also confirm that connecting to a
> Firebird 2.5 server is quick when IPv6 is inactive on localhost.

Now that the technical reasons for this one-second delay are
clarified: is there something that can/will be done to improve the
situation? Do I need to open a ticket?

Regards

Stefan



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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Stefan Heymann]

>>> I can confirm that: using a 3.0 fbclient to connect to a *remote* 2.5
>>> server is quick. The problem seems to be related to the local machine
>>> (I didn't manage to switch IPv6 off for my localhost on Windows).
>
>>Just add (uncomment) following line at System32\drivers\etc\hosts:
>
>> 127.0.0.1   localhost

Ok, that did the trick. I can now also confirm that connecting to a
Firebird 2.5 server is quick when IPv6 is inactive on localhost.

Best Regards

Stefan


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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Stefan Heymann]

> Sean, can you confirm that there is no delay when using 3.0 fbclient
> with remote 2.5 server?

I can confirm that: using a 3.0 fbclient to connect to a *remote* 2.5
server is quick. The problem seems to be related to the local machine
(I didn't manage to switch IPv6 off for my localhost on Windows).

Regards

Stefan


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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Vlad Khorsun]

28.04.2016 18:48, Stefan Heymann wrote:
>> Sean, can you confirm that there is no delay when using 3.0 fbclient
>> with remote 2.5 server?
>
> I can confirm that: using a 3.0 fbclient to connect to a *remote* 2.5
> server is quick. The problem seems to be related to the local machine
> (I didn't manage to switch IPv6 off for my localhost on Windows).

   Just add (uncomment) following line at System32\drivers\etc\hosts:

127.0.0.1   localhost

Note, you should do it using admin privileges (escalated)

Hope it helps,
Vlad

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Leyne, Sean]

> > Unfortunately, this function available in server OS starting with
> > Win2003 but is only available on client OS as of Win8.1 (the page
> > awkwardly refers to Vista support -- which would imply Win7+)
> 
> Vista and up are supported(maybe some XP versions, but I think Microsoft
> removed those references from their documentation). With the reference
> for Windows 8.1, that is related to the Windows Store apps(Modern UI and
> Universal Windows Platform).

Thanks for your review.

Given it is supported in Win2003, it would make sense that it would be also 
supported by all client OS released with/after Win2003.  

As for XP, I agree, without creating a test app it is difficult to know/say 
whether the function is supported.  I tried searching the MS TechNet site for 
details of XP support, found nothing.

In fact, Win2003 may not even be supported.  The following link describes the 
function as being introduced only with Win2008/Vista *not Win2003*.  
https://technet.microsoft.com/en-us/library/bb726965.aspx


Sean


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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Daniel Rail]

Hi,

At April 27, 2016, 1:16 PM, Leyne, Sean wrote:

> That is likely why MS introduced WSAConnectByList function, which
> returns a connection for the first available hosts based on IP
> address list (both IPv4 and IPv6 addresses). 
> (https://msdn.microsoft.com/en-us/library/windows/desktop/ms741554(v=vs.85).aspx)

> Unfortunately, this function available in server OS starting with
> Win2003 but is only available on client OS as of Win8.1 (the page
> awkwardly refers to Vista support -- which would imply Win7+)

Vista and up are supported(maybe some XP versions, but I think
Microsoft removed those references from their documentation). With the
reference for Windows 8.1, that is related to the Windows Store
apps(Modern UI and Universal Windows Platform).

-- 
Best regards,
 Daniel Rail
 Senior Software Developer
 ACCRA Solutions Inc. (www.accra.ca)
 ACCRA Med Software Inc. (www.filopto.com)


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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Leyne, Sean]

>"Solutions" that only shift the problem into less visited area or drop the
> problem to users is not a way to go.
> 
>Quoting RFC 6724:
> 
> >Well-behaved applications SHOULD NOT simply use the first address
> >returned from an API such as getaddrinfo() and then give up if it
> >fails.  For many applications, it is appropriate to iterate through
> >the list of addresses returned from getaddrinfo() until a working
> >address is found.  *For other applications, it might be appropriate to
> >try multiple addresses in parallel (e.g., with some small delay in
> >between) and use the first one to succeed.*

That is likely why MS introduced WSAConnectByList function, which returns a 
connection for the first available hosts based on IP address list (both IPv4 
and IPv6 addresses).  
(https://msdn.microsoft.com/en-us/library/windows/desktop/ms741554(v=vs.85).aspx)

Unfortunately, this function available in server OS starting with Win2003 but 
is only available on client OS as of Win8.1 (the page awkwardly refers to Vista 
support -- which would imply Win7+)


Sean


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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Leyne, Sean]

> Sean, can you confirm that there is no delay when using 3.0 fbclient with
> remote 2.5 server?

I don't have that config available, perhaps Stefan can try and report back.


Sean

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Michal Kubecek]

On Wed, Apr 27, 2016 at 03:42:16PM +0200, Dimitry Sibiryakov wrote:
> 27.04.2016 15:33, Michal Kubecek wrote:
> > After a one second timeout, apparently. And that's exactly where the
> > problem is.
> 
> And the most reliable solution for the problem is to try other
> addresses without waiting for timeout error from the first one. All
> the rest will fail under some circumstances as I already wrote.

I already explained why this _workaround_ is wrong - and what the
_solution_ is.

   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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

27.04.2016 16:31, Michal Kubecek wrote:
> I already explained why this_workaround_  is wrong - and what the
> _solution_  is.

   "Solutions" that only shift the problem into less visited area or drop the 
problem to 
users is not a way to go.

   Quoting RFC 6724:

>Well-behaved applications SHOULD NOT simply use the first address
>returned from an API such as getaddrinfo() and then give up if it
>fails.  For many applications, it is appropriate to iterate through
>the list of addresses returned from getaddrinfo() until a working
>address is found.  *For other applications, it might be appropriate to
>try multiple addresses in parallel (e.g., with some small delay in
>between) and use the first one to succeed.*


-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

27.04.2016 15:33, Michal Kubecek wrote:
> After a one second timeout, apparently. And that's exactly where the
> problem is.

   And the most reliable solution for the problem is to try other addresses 
without 
waiting for timeout error from the first one. All the rest will fail under some 
circumstances as I already wrote.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Michal Kubecek]

On Wed, Apr 27, 2016 at 03:24:28PM +0200, Dimitry Sibiryakov wrote:
> 27.04.2016 15:08, Michal Kubecek wrote:
> > The problem is in local system setup; first it tells the client
> > where to connect and then it hides the fact that the connection didn't
> > succeed. That's plain wrong.
> 
> Use only first structure returned by getaddrinfo() and you'll get your
> error.

After a one second timeout, apparently. And that's exactly where the
problem is. If connect() failed within the roundtrip to the hop unable
to forward the syn packet on, you wouldn't observe any problem.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Michal Kubecek]

On Wed, Apr 27, 2016 at 09:57:36AM -0300, Adriano dos Santos Fernandes wrote:
> >
> Firebird is not probably (I think) the unique application in the world
> connecting via tcp (ipv4 or ipv6) to things. Or is it?

Definitely not.

> Is the problem happening with other applications and how they are
> solving it or not?

I'm not familiar with the situation on Windows but few years ago when
linux distributions started to have IPv6 enabled by default and popular
websites started to provide  records (and serve IPv6 requests), this
type of problem was observed quite often. To my knowledge, the solution
mostly was to either disable IPv6 or adjust /etc/gai.conf to prefer IPv4
addresses on hosts without IPv6 connectivity, sometimes also adjusting
firewalls so that outgoing IPv6 fail properly rather than being silently
dropped. Some client applications also provide means to enforce IPv4
(e.g. '-4' command line option or a configuration directive).

  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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

27.04.2016 15:08, Michal Kubecek wrote:
> The problem is in local system setup; first it tells the client
> where to connect and then it hides the fact that the connection didn't
> succeed. That's plain wrong.

   Use only first structure returned by getaddrinfo() and you'll get your error.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Michal Kubecek]

On Wed, Apr 27, 2016 at 02:54:11PM +0200, Dimitry Sibiryakov wrote:
> 27.04.2016 11:27, Michal Kubecek wrote:
> > Please stop pretending the problem is way worse than it actually is.
> 
> It is enough that the problem exists and can be solved without tuning
> of global OS settings.

"solve" -> "worked around"

Firebird code is not the problem, it does exactly what it is supposed
to. The problem is in local system setup; first it tells the client
where to connect and then it hides the fact that the connection didn't
succeed. That's plain wrong.

We can - and we IMHO should - provide a workaround but we shouldn't
pretend there is something wrong in using the address system library
told us to use.

  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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Adriano dos Santos Fernandes]

On 27/04/2016 09:54, Dimitry Sibiryakov wrote:
> 27.04.2016 11:27, Michal Kubecek wrote:
>> Please stop pretending the problem is way worse than it actually is.
>It is enough that the problem exists and can be solved without tuning of 
> global OS 
> settings.
>
> PS: I wonder why Vlad still hasn't demanded to rollback the path completely 
> and 
> immediately as he used to...
>
Firebird is not probably (I think) the unique application in the world
connecting via tcp (ipv4 or ipv6) to things. Or is it?

Is the problem happening with other applications and how they are
solving it or not?


Adriano


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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

27.04.2016 11:27, Michal Kubecek wrote:
> Please stop pretending the problem is way worse than it actually is.

   It is enough that the problem exists and can be solved without tuning of 
global OS 
settings.

PS: I wonder why Vlad still hasn't demanded to rollback the path completely and 
immediately as he used to...

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

27.04.2016 0:11, Leyne, Sean wrote:
> 2-  Slowness only occurs when using "localhost" with v3 client and v2.5 
> server -- a very unusual situation (why would you have new client installed 
> on same host as old server?)

   No, this problem will occur on any host with multiple IP addresses when 
Firebird is not 
reachable on the first one in list. Localhost is just the most common case.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Michal Kubecek]

On Wed, Apr 27, 2016 at 11:03:33AM +0200, Dimitry Sibiryakov wrote:
> 27.04.2016 0:11, Leyne, Sean wrote:
> > 2-  Slowness only occurs when using "localhost" with v3 client*and*  v2.5 
> > server -- a very unusual situation (why would you have new client installed 
> > on same host as old server?)
> 
> No, this problem occur on any host with multiple IP addresses when
> Firebird is not reachable on the first in list.

...and either the host is set up not to generate a TCP reset packet or
ICMP destination unreachable message or something eats it between the
endpoints.

Please stop pretending the problem is way worse than it actually is.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

27.04.2016 0:11, Leyne, Sean wrote:
> 2-  Slowness only occurs when using "localhost" with v3 client*and*  v2.5 
> server -- a very unusual situation (why would you have new client installed 
> on same host as old server?)

   No, this problem occur on any host with multiple IP addresses when Firebird 
is not 
reachable on the first in list. Localhost is just most common case.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[alex]

27.04.2016 01:11, Leyne, Sean пишет:
>
>> To let rumors that Firebird is unbearable slow to spread is a bad thing 
>> too.
> 1-  1 sec is not "unbearable"!
>
> 2-  Slowness only occurs when using "localhost" with v3 client *and* v2.5 
> server -- a very unusual situation (why would you have new client installed 
> on same host as old server?)
>
> 3-  The performance problem is with Win API/DNS resolving the IPv4 address of 
> "localhost" -- "127.0.0.1" is an IPv4 IP so DNS resolution is completely 
> bypassed, which is why is doesn't suffer any connection delay.
>
> 4-  The performance "problem" can be resolved by disabling IPv6 on the host 
> system.  (I have asked Stefan to confirm same)
>- v2.5 is known not to support IPv6.
>- We have had to disable IPv6, on Microsoft's instructions, to address 
> DNS issues with IPv4 on hosts in our Win2012R2 clusters.
>
>
> So, IMO, the only rumour will be "_don't mix v3 and v2.x client/server on 
> same host_"
>
>

Sean, can you confirm that there is no delay when using 3.0 fbclient 
with remote 2.5 server?


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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Leyne, Sean]

>To let rumors that Firebird is unbearable slow to spread is a bad thing 
> too.

1-  1 sec is not "unbearable"!

2-  Slowness only occurs when using "localhost" with v3 client *and* v2.5 
server -- a very unusual situation (why would you have new client installed on 
same host as old server?)

3-  The performance problem is with Win API/DNS resolving the IPv4 address of 
"localhost" -- "127.0.0.1" is an IPv4 IP so DNS resolution is completely 
bypassed, which is why is doesn't suffer any connection delay.

4-  The performance "problem" can be resolved by disabling IPv6 on the host 
system.  (I have asked Stefan to confirm same)
  - v2.5 is known not to support IPv6.
  - We have had to disable IPv6, on Microsoft's instructions, to address 
DNS issues with IPv4 on hosts in our Win2012R2 clusters.


So, IMO, the only rumour will be "_don't mix v3 and v2.x client/server on same 
host_"


Sean

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Leyne, Sean]

Stefan,

> The problem is when I use the Fb3 client to connect to a Fb2.5 database.
> Then there is this one second delay.
> 
> To sum things up:
> 
> Connection time using the new Fb3 fbclient.dll:
> - 3.0 database using "localhost" - quick
> - 3.0 database using "127.0.0.1" - quick
> - 2.5 database using "localhost" - slow
> - 2.5 database using "127.0.0.1" - quick

Please confirm:

1- The host has both IPv4 and IPv6 configured/active?
2- IPv6 is required?
3- How is connection time if IPv6 is disabled on host?


Sean


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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

26.04.2016 22:40, Mark Rotteveel wrote:
> Firebird works without configuration.

   To let rumors that Firebird is unbearable slow to spread is a bad thing too.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Mark Rotteveel]

Now you're being overly dramatic. Firebird works without configuration.
Mark

- Bericht beantwoorden -
Van: "Dimitry Sibiryakov" 
Aan: "For discussion among Firebird Developers" 

Onderwerp: [Firebird-devel] Performance of fbclient.dll of recent snapshots
Datum: di, apr. 26, 2016 22:23

26.04.2016 22:03, Michal Kubecek wrote:
> But now I'm starting to worry that any
> solution that is not handling his corner case out of the box without
> waiting for a timeout is not going to satisfy him.

Any solution that requires a special configuration of host OS in order to make 
Firebird 
work on it is unacceptable.

-- 
WBR, SD.

--
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--
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;zFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

26.04.2016 22:03, Michal Kubecek wrote:
> But now I'm starting to worry that any
> solution that is not handling his corner case out of the box without
> waiting for a timeout is not going to satisfy him.

   Any solution that requires a special configuration of host OS in order to 
make Firebird 
work on it is unacceptable.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Michal Kubecek]

On Tue, Apr 26, 2016 at 09:56:30PM +0200, Michal Kubecek wrote:
> On Tue, Apr 26, 2016 at 07:02:48PM +0200, Dimitry Sibiryakov wrote:
> > 26.04.2016 18:58, Michal Kubecek wrote:
> > > Disabling it unconditionally is not a good idea. Perhaps it could be
> > > controlled via firebird.conf but I would still prefer the connection
> > > string as more flexible.
> > 
> >Extract IPv6 support from remote to a separate plugin.
> 
> That doesn't make much sense to me. Actually one of my long term plans
> is to refactor struct rem_port into a hierarchy of classes. But I don't
> see much benefit in providing support for different protocols in the
> form of plugins.

Forgot one important point: vast majority of the code is common, only
a very small part handles the differences between IPv4 and IPv6.

   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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Michal Kubecek]

On Tue, Apr 26, 2016 at 07:02:48PM +0200, Dimitry Sibiryakov wrote:
> 26.04.2016 18:58, Michal Kubecek wrote:
> > Disabling it unconditionally is not a good idea. Perhaps it could be
> > controlled via firebird.conf but I would still prefer the connection
> > string as more flexible.
> 
>Extract IPv6 support from remote to a separate plugin.

That doesn't make much sense to me. Actually one of my long term plans
is to refactor struct rem_port into a hierarchy of classes. But I don't
see much benefit in providing support for different protocols in the
form of plugins.

While I'm not opposed to the possibility to confine the client to IPv4
(or IPv6), I definitely don't like the idea of making that a default.
Seriously, it's 2016, not 1996.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Mark Rotteveel]

Or you use netsh (on windows) to change the precedence (prefixpolicies) of 
using ipv4 or ipv6 for a specific subnet, or /etc/gai.conf on Linux.
A lot simpler than not having ipv6 for a host just because you use a new client 
lib with an old Firebird version.

Mark

- Bericht beantwoorden -
Van: "Michal Kubecek" 
Aan: "For discussion among Firebird Developers" 

Onderwerp: [Firebird-devel] Performance of fbclient.dll of recent snapshots
Datum: di, apr. 26, 2016 18:58

On Tue, Apr 26, 2016 at 05:57:19PM +0200, Dimitry Sibiryakov wrote:
> 26.04.2016 17:48, Stefan Heymann wrote:
> > we need the URL type db string
> > solution described by Michael so only IPv4 gets tried by the client.
> 
> This solution requires to change every connection string in every
> application worked with Firebird which is often hard-coded.

Not necessarily. The example with "localhost" name is rather artificial.
I'm pretty sure client using linked libfbclient accessing a 2.5 server
running on the same machine is not a common production scenario.

If it's a different machine, there are other options, e.g.

- do not give the name an  record
- configure it in a way where the IPv6 connection fails normally

> Disabling IPv6 in client is more realistic solution for now.

Disabling it unconditionally is not a good idea. Perhaps it could be
controlled via firebird.conf but I would still prefer the connection
string as more flexible.

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--
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;zFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

26.04.2016 18:58, Michal Kubecek wrote:
> Disabling it unconditionally is not a good idea. Perhaps it could be
> controlled via firebird.conf but I would still prefer the connection
> string as more flexible.

   Extract IPv6 support from remote to a separate plugin.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Michal Kubecek]

On Tue, Apr 26, 2016 at 05:57:19PM +0200, Dimitry Sibiryakov wrote:
> 26.04.2016 17:48, Stefan Heymann wrote:
> > we need the URL type db string
> > solution described by Michael so only IPv4 gets tried by the client.
> 
> This solution requires to change every connection string in every
> application worked with Firebird which is often hard-coded.

Not necessarily. The example with "localhost" name is rather artificial.
I'm pretty sure client using linked libfbclient accessing a 2.5 server
running on the same machine is not a common production scenario.

If it's a different machine, there are other options, e.g.

  - do not give the name an  record
  - configure it in a way where the IPv6 connection fails normally

> Disabling IPv6 in client is more realistic solution for now.

Disabling it unconditionally is not a good idea. Perhaps it could be
controlled via firebird.conf but I would still prefer the connection
string as more flexible.

  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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

26.04.2016 17:48, Stefan Heymann wrote:
> we need the URL type db string
> solution described by Michael so only IPv4 gets tried by the client.

   This solution requires to change every connection string in every 
application worked 
with Firebird which is often hard-coded.
   Disabling IPv6 in client is more realistic solution for now.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

26.04.2016 17:48, Stefan Heymann wrote:
> Situation Nr. 1 is a pre-Firebird3 server.

   No, it is number 2. Number 1 is no Firebird at all.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Stefan Heymann]

>If a server has both IPv4 and IPv6 addresses, there can be four cases:

> 1) Firebird doesn't listen on both of them
> 2) Firebird listens on IPv4 only
> 3) Firebird listens on IPv6 only
> 4) Firebird listens on both

>Whatever priority you set up, in one case of four you'll get slow 
> connection.

Situation Nr. 1 is a pre-Firebird3 server. I think for the next 5 to 10
years we will have a lot of situations where an application uses the
Fb3 client to connect to a Fb 1.x/2.x server.

So if you want to avoid a situation where there are several connection
attemps going on at the same time, we need the URL type db string
solution described by Michael so only IPv4 gets tried by the client.

Regards

Stefan





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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

   If a server has both IPv4 and IPv6 addresses, there can be four cases:

1) Firebird doesn't listen on both of them
2) Firebird listens on IPv4 only
3) Firebird listens on IPv6 only
4) Firebird listens on both

   Whatever priority you set up, in one case of four you'll get slow connection.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

26.04.2016 13:25, Michal Kubecek wrote:
> That's completely different situation. With bittorrent, you want to
> access all targets, not one of them

   Yes, but it is a good example how to work with a swarm of unreliable 
servers. Exactly 
matches situation in this topic where connection must be established ASAP even 
if some 
addresses (servers) are dead.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Vlad Khorsun]

26.04.2016 14:12, Michal Kubecek wrote:
> On Tue, Apr 26, 2016 at 12:05:44PM +0200, Dimitry Sibiryakov wrote:
>> 26.04.2016 12:01, Stefan Heymann wrote:
>>> So I think Michael's idea to expand the URL type database strings is a
>>> good idea:
>>
>> No, it is just a workaround.
>> Good solution will be to connect to all host addresses at once using
>> connection that is established as a first.
>
> No, please. I suspected you might have had something like this in you
> mind but hoped I was wrong.

   Don't worry. Such code will not be accepted. At least as described above.

Regards,
Vlad


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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Michal Kubecek]

On Tue, Apr 26, 2016 at 01:16:17PM +0200, Dimitry Sibiryakov wrote:
> 26.04.2016 13:12, Michal Kubecek wrote:
> > Are you aware of other client applications doing this for TCP based
> > protocols?
> 
>Any torrent client.

That's completely different situation. With bittorrent, you want to
access all targets, not one of them (unless I guessed wrong what
connection you meant).

   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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

26.04.2016 13:12, Michal Kubecek wrote:
> Are you aware of other client applications doing this for TCP based
> protocols?

   Any torrent client.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

26.04.2016 12:44, Stefan Heymann wrote:
> Is there a chance that one of them will be
> implemented?

   I have in plans to implement parallel connect in v4 as a part of cluster 
solution.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Stefan Heymann]

> 26.04.2016 12:01, Stefan Heymann wrote:
>> So I think Michael's idea to expand the URL type database strings is a
>> good idea:

>No, it is just a workaround.
>Good solution will be to connect to all host addresses at once using 
> connection that is
> established as a first.

Sounds good. Now we have two solutions that are better than the
one-second wait. Is there a chance that one of them will be
implemented?


Regards

Stefan



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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

26.04.2016 12:01, Stefan Heymann wrote:
> So I think Michael's idea to expand the URL type database strings is a
> good idea:

   No, it is just a workaround.
   Good solution will be to connect to all host addresses at once using 
connection that is 
established as a first.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Stefan Heymann]

> 25.04.2016 22:34, Michal Kubecek wrote:
>> No, that's not the reason. If everything works the way it's supposed to,
>> the connection fails within one roundtrip and client doesn't have to
>> wait for a full second. For :: address, there is even less reason for
>> having to wait for a timeout.

>Unless there is a black hole-type firewall like Win7's FW in stealth mode:
> https://technet.microsoft.com/en-us/library/dd448557%28WS.10%29

So I think Michael's idea to expand the URL type database strings is a
good idea:

> We might also consider extending the new connection string format
> inet://... to variants inet4://... and inet6://... which would enforce
> AF_INET or AF_INET6.

because then I can specify that "localhost" is meant to be an IPv4
localhost and the client can skip the IPv6 attempt.

   inet4://localhost/mydb

Best Regards

Stefan


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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

25.04.2016 22:34, Michal Kubecek wrote:
> No, that's not the reason. If everything works the way it's supposed to,
> the connection fails within one roundtrip and client doesn't have to
> wait for a full second. For :: address, there is even less reason for
> having to wait for a timeout.

   Unless there is a black hole-type firewall like Win7's FW in stealth mode: 
https://technet.microsoft.com/en-us/library/dd448557%28WS.10%29

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Michal Kubecek]

On Mon, Apr 25, 2016 at 05:46:24PM +0200, Dimitry Sibiryakov wrote:
> 25.04.2016 17:42, Michal Kubecek wrote:
> > A 2.5 server, however, does only listen to IPv4 connections and for
> > some reason, client has to wait for timeout of the connection to ::
> > which is tried first.
> 
> Reason is simple: addresses for a host are tried one-by-one.

No, that's not the reason. If everything works the way it's supposed to,
the connection fails within one roundtrip and client doesn't have to
wait for a full second. For :: address, there is even less reason for
having to wait for a timeout.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

25.04.2016 17:42, Michal Kubecek wrote:
> A 2.5 server, however, does only listen to IPv4 connections and for some
> reason, client has to wait for timeout of the connection to :: which is
> tried first.

   Reason is simple: addresses for a host are tried one-by-one.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Michal Kubecek]

On Mon, Apr 25, 2016 at 05:07:13PM +0200, Stefan Heymann wrote:
> >>Try to set option IPv6V6Only to true in firebird.conf and see if
> >>it makes any difference.
> 
> > This directive affects only listening sockets (i.e. a server) and
> > would actually do the exact opposite: make the server listening on
> > (default) address :: accept only IPv6 connections (to any address).
> > To accept only IPv4 connections, you would rather want
> > "RemoteBindAddress 0.0.0.0" (or e.g. 127.0.0.1).
> 
> We're now talking about Fb3 servers, right? Wenn I connect to a Fb3
> server (using the Fb3 client and "localhost" as the host name), the
> connection is quick.
> 
> The problem is when I use the Fb3 client to connect to a Fb2.5
> database. Then there is this one second delay.

Yes, that's why I explained that the IPv6V6Only directive cannot help
you as it does only affect server so that it can't change the behaviour
of a 3.0 client (and a 2.5 server wouldn't recognize it at all).

> Connection time using the new Fb3 fbclient.dll:
> - 3.0 database using "localhost" - quick
> - 3.0 database using "127.0.0.1" - quick
> - 2.5 database using "localhost" - slow
> - 2.5 database using "127.0.0.1" - quick

This agrees with the theory: "localhost" resolves to both :: and
127.0.0.1 and according to your system's rules, :: is preferred. With
3.0 database listening to any IPv6 or IPv4 connection, both are quick.
A 2.5 server, however, does only listen to IPv4 connections and for some
reason, client has to wait for timeout of the connection to :: which is
tried first.

  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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Stefan Heymann]

>>Try to set option IPv6V6Only to true in firebird.conf and see if it
>>makes any difference.

> This directive affects only listening sockets (i.e. a server) and would
> actually do the exact opposite: make the server listening on (default)
> address :: accept only IPv6 connections (to any address). To accept only
> IPv4 connections, you would rather want "RemoteBindAddress 0.0.0.0" (or
> e.g. 127.0.0.1).

We're now talking about Fb3 servers, right? Wenn I connect to a Fb3
server (using the Fb3 client and "localhost" as the host name), the
connection is quick.

The problem is when I use the Fb3 client to connect to a Fb2.5
database. Then there is this one second delay.

To sum things up:

Connection time using the new Fb3 fbclient.dll:
- 3.0 database using "localhost" - quick
- 3.0 database using "127.0.0.1" - quick
- 2.5 database using "localhost" - slow
- 2.5 database using "127.0.0.1" - quick

Regards

Stefan



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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Michal Kubecek]

On Sat, Apr 23, 2016 at 12:13:26PM +0200, Dimitry Sibiryakov wrote:
> 23.04.2016 12:01, Stefan Heymann wrote:
> >> It seems that your problem is due to slow host name to IP address
> >> >resolution (i.e. DNS), not with Firebird functionality.
> > But my 2.5 fbclient does not show this delay. So I don't assume there
> > is a problem with IP resolution.
> 
>Try to set option IPv6V6Only to true in firebird.conf and see if it
>makes any difference.

This directive affects only listening sockets (i.e. a server) and would
actually do the exact opposite: make the server listening on (default)
address :: accept only IPv6 connections (to any address). To accept only
IPv4 connections, you would rather want "RemoteBindAddress 0.0.0.0" (or
e.g. 127.0.0.1).

  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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Stefan Heymann]

>  Try to set option IPv6V6Only to true in firebird.conf and see if it makes 
> any difference.

I copied a firebird.conf from Fb3 to the client folder, changed that
to true (1). There's no difference. Still that second.

Regards

Stefan



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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

23.04.2016 12:01, Stefan Heymann wrote:
>> It seems that your problem is due to slow host name to IP address
>> >resolution (i.e. DNS), not with Firebird functionality.
> But my 2.5 fbclient does not show this delay. So I don't assume there
> is a problem with IP resolution.

   Try to set option IPv6V6Only to true in firebird.conf and see if it makes 
any difference.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dimitry Sibiryakov]

23.04.2016 12:01, Stefan Heymann wrote:
> If there is no other solution to come around this problem, I also
> think that this would be easily understandable.

   Much simpler will be to disalbe IPV6 support by default.

-- 
   WBR, SD.

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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Stefan Heymann]

> It seems that your problem is due to slow host name to IP address
> resolution (i.e. DNS), not with Firebird functionality.

But my 2.5 fbclient does not show this delay. So I don't assume there
is a problem with IP resolution.

> For Windows, the policy table seems to be managed with netsh command:
> https://technet.microsoft.com/en-us/library/cc740203(v=ws.10).aspx#BKMK_5
> http://www.colorconsole.de/cmd/en/Windows_Vista/netsh/interface/ipv6/add/prefixpolicy.htm

That is *much* too complicated for me and my customers. Especially
when you consider that you'd have to do that on every client computer
that wants to use a Firebird based application.

>> We might also consider extending the new connection string format
>> inet://... to variants inet4://... and inet6://... which would enforce
>> AF_INET or AF_INET6.
>
> This may be a good workaround.

If there is no other solution to come around this problem, I also
think that this would be easily understandable.

Best Regards

Stefan



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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Dmitry Yemanov]

22.04.2016 18:03, Michal Kubecek wrote:

> We might also consider extending the new connection string format
> inet://... to variants inet4://... and inet6://... which would enforce
> AF_INET or AF_INET6.

This may be a good workaround.


Dmitry


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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Leyne, Sean]

Michael,

> For Windows, the policy table seems to be managed with netsh command:
> 
>   https://technet.microsoft.com/en-
> us/library/cc740203(v=ws.10).aspx#BKMK_5
> 
> http://www.colorconsole.de/cmd/en/Windows_Vista/netsh/interface/ipv6/
> add/prefixpolicy.htm

Thanks for the pointers.

But these further reinforce my point that Firebird should not need to concern 
itself with managing this policy, it is the OS/network admin which should be 
doing so.


Sean


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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Leyne, Sean]

> I don't know what gai.conf is (it's not in my Firebird folder). It should be 
> as
> easy as possible and as less configuration as possible when we install the
> software on the servers of our customers.
> 
> As we still mainly live in an IPv4 world (especially in LANs) - would it be
> possible to make IPv4 the preferred protocol as the Firebird default so we
> don't need settings in obscure conf files?

AFAICT, gai.conf is not a Windows file.  It is a Linux OS/networking config 
file.

I do not agree that Firebird should have any preference for IPv4. Firebird 
should use all available IP paths to connect to a database, it is for the OS to 
choose the best paths.

There are mechanisms in Windows to manage the preferences (e.g. IPv6 can be 
disabled at the adapter level, host name/IP address can be defined/specified in 
etc/hosts. file).

It seems that your problem is due to slow host name to IP address resolution 
(i.e. DNS), not with Firebird functionality.


Sean


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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Alex Peshkoff]

On 04/22/2016 06:13 PM, Stefan Heymann wrote:
> --- Alex Peshkoff
>
>> Stefan, I've made a test. It's dev-build therefore it's not too fast but
>> look here:
>> [...]
>> I do not notice 3.0 client to work slower.
> Sorry, I forgot to mention that I mean Windows, not Linux.

I might guess myself - .dll was mentioned :)



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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Stefan Heymann]

--- Alex Peshkoff

> Stefan, I've made a test. It's dev-build therefore it's not too fast but
> look here:
> [...]
> I do not notice 3.0 client to work slower.

Sorry, I forgot to mention that I mean Windows, not Linux.


--- Michal Kubecek

> Do you see the same delay when identifying the server by IP address
> (rather than by name)?

It's actually quick when I use the IPv4 address and not the host name.

> If this is the problem discussed before (waiting for the IPv6
> connection attempt to time out), it should be possible to change the
> preference via gai.conf (RFC 3484).

I don't know what gai.conf is (it's not in my Firebird folder). It
should be as easy as possible and as less configuration as possible
when we install the software on the servers of our customers.

As we still mainly live in an IPv4 world (especially in LANs) - would
it be possible to make IPv4 the preferred protocol as the Firebird
default so we don't need settings in obscure conf files?


Regards

Stefan






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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Alex Peshkoff]

On 04/22/2016 06:10 PM, Michal Kubecek wrote:
> 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;
>> real0m0.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;
>> real0m0.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).

Probably. I have not paid an attention that it's windows problem.


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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Michal Kubecek]

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;
> real0m0.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;
> real0m0.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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Michal Kubecek]

On Fri, Apr 22, 2016 at 03:59:52PM +0200, Stefan Heymann wrote:
> > However, the new fbclient (3.0.0.31529) connecting to old Firebird
> > servers (2.5 and earlier) is also taking 1 second (compared to +/- 25-30
> > milliseconds with Firebird 3 beta 1 fbclient and 15 milliseconds with 
> > Firebird 2.5.3 fbclient), so we do have a problem.
> 
> 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.

Do you see the same delay when identifying the server by IP address
(rather than by name)?

> Are there plans to speed this up? It's quite annoying.

If this is the problem discussed before (waiting for the IPv6 connection
attempt to time out), it should be possible to change the preference via
gai.conf (RFC 3484).

We might also consider extending the new connection string format
inet://... to variants inet4://... and inet6://... which would enforce
AF_INET or AF_INET6.

  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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Alex Peshkoff]

On 04/22/2016 04:59 PM, Stefan Heymann wrote:
>> However, the new fbclient (3.0.0.31529) connecting to old Firebird
>> servers (2.5 and earlier) is also taking 1 second (compared to +/- 25-30
>> milliseconds with Firebird 3 beta 1 fbclient and 15 milliseconds with
>> Firebird 2.5.3 fbclient), so we do have a problem.
> 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;
real0m0.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;
real0m0.161s

I do not notice 3.0 client to work slower.


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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Stefan Heymann]

> However, the new fbclient (3.0.0.31529) connecting to old Firebird
> servers (2.5 and earlier) is also taking 1 second (compared to +/- 25-30
> milliseconds with Firebird 3 beta 1 fbclient and 15 milliseconds with 
> Firebird 2.5.3 fbclient), so we do have a problem.

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.


Regards

Stefan


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

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Mark Rotteveel]

On 4-1-2015 11:30, Dmitry Yemanov wrote:
 04.01.2015 13:12, Mark Rotteveel wrote:

 When running with against 3.0.0.31529 server, the performance is better.
 An attach takes +/- 45 milliseconds. This is still 3x slower than with
 the old fbclient.

 Could it be just an Srp vs Legacy auth difference?

Yes, it looks like it: the Firebird 3 beta 1 fbclient against Firebird 3 
beta 1 server also takes +/- 45 milliseconds. So lets ignore that part.

However, the new fbclient (3.0.0.31529) connecting to old Firebird 
servers (2.5 and earlier) is also taking 1 second (compared to +/- 25-30 
milliseconds with Firebird 3 beta 1 fbclient and 15 milliseconds with 
Firebird 2.5.3 fbclient), so we do have a problem.

Mark
-- 
Mark Rotteveel

--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Alex Peshkoff]

On 12/31/14 18:47, Mark Rotteveel wrote:
 I was just running a test with the native implementation of Jaybird and
 the fbclient.dll of todays snapshot (3.0.0.31529-0_x64) is substantially
 slower than the fbclient.dll of Firebird 3 beta 1 (3.0.0.31374).

 A test run with the snapshot fbclient.dll takes +/- 1 hour, while the
 same test run with the beta 1 fbclient.dll takes 5.5 minutes (both are
 running against a Firebird 3 beta 1 server).

 Any idea what could cause this change in performance?


Mark, using such simple test in employee

select * from country full join country on 1=1 full join country on 1=1 
full join country on 1=1;

I see absolutely no difference between beta1 and trunk at least on linux.



--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

[Mark Rotteveel]

On 4-1-2015 10:50, Mark Rotteveel wrote:
 I have looked at it closer. The problem seems to be during attach. With
 a 2.5.3 fbclient, it takes +/- 15 milliseconds, with the 3.0.0.31529
 fbclient +/- a second. As it is in attach, it might be related to the
 IPv6 changes. However explicitly specifying 127.0.0.1 instead of
 localhost makes no difference

 This is on Windows 8.1 (64 bit).

 However I haven't checked with the same server version as the client
 yet, will do that now.

When running with against 3.0.0.31529 server, the performance is better. 
An attach takes +/- 45 milliseconds. This is still 3x slower than with 
the old fbclient. Looking at netstat, the established connections are IPv6.

Mark
-- 
Mark Rotteveel

--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel