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

2016-04-27 Thread 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 tho

[Firebird-devel] [FB-Tracker] Created: (CORE-5215) Can not create view with quoted name if: 1) it has length = 16, and 2) starts from 15 non-ascii characters and 3) last character is '#'

2016-04-27 Thread Pavel Zotov (JIRA)
Can not create view with quoted name if: 1) it has length = 16, and 2) starts from 15 non-ascii characters and 3) last character is '#' --- Key: COR

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

2016-04-27 Thread 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/ms741

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

2016-04-27 Thread Michal Kubecek
On Wed, Apr 27, 2016 at 04:48:53PM +0200, Dimitry Sibiryakov wrote: >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

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

2016-04-27 Thread 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 > >

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

2016-04-27 Thread 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

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

2016-04-27 Thread 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

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

2016-04-27 Thread 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 S

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

2016-04-27 Thread 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 circum

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

2016-04-27 Thread 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

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

2016-04-27 Thread 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 >

[Firebird-devel] File names iteration

2016-04-27 Thread Dimitry Sibiryakov
Hello, All. Do we really need file name iterators in both path_utils and ScanDir? -- WBR, SD. -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep p

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

2016-04-27 Thread 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. --

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

2016-04-27 Thread 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" -> "wor

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

2016-04-27 Thread 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 ha

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

2016-04-27 Thread 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 immedia

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

2016-04-27 Thread 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 F

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

2016-04-27 Thread 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?)

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

2016-04-27 Thread 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 Fireb

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

2016-04-27 Thread 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 n