[Firebird-devel] bitfield overflows in intl/collations

2016-04-26 Thread Michal Kubecek
Hello, I'm looking at gcc6 compiler warnings with current master and while most of them are benign, I think I found some that may be significant: intl/collations/xx885913lt.h:821:1: warning: large integer implicitly truncated to unsigned type [-Woverflow] intl/collations/pw1252i850.h:832:1: warn

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

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

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

2016-04-26 Thread 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 databa

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

2016-04-26 Thread 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 issu

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

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

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

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

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

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

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

2016-04-26 Thread Michal Kubecek
On Tue, Apr 26, 2016 at 08:06:22PM +0200, Mark Rotteveel wrote: > 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 clien

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

2016-04-26 Thread Dimitry Sibiryakov
26.04.2016 21:56, Michal Kubecek wrote: > 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. But that's exactly

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

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

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

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

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

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

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

2016-04-26 Thread 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 > applicat

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

2016-04-26 Thread 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 cl

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

2016-04-26 Thread 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 Appli

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

2016-04-26 Thread 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 > co

Re: [Firebird-devel] Firebird.pas missing

2016-04-26 Thread Mark Rotteveel
On 2016-04-26 14:17, Daniel Rail wrote: > Hi, > > I downloaded the install and the zip file for Firebird 3.0 official > release. And, I noticed in the examples the file cryptDb.pas, but it > relies on Firebird.pas which is not included with the release. Where > can someone find the Firebird.pas fil

[Firebird-devel] Firebird.pas missing

2016-04-26 Thread Daniel Rail
Hi, I downloaded the install and the zip file for Firebird 3.0 official release. And, I noticed in the examples the file cryptDb.pas, but it relies on Firebird.pas which is not included with the release. Where can someone find the Firebird.pas file? -- Best regards, Daniel Rail Senior System E

Re: [Firebird-devel] IBPP or what?

2016-04-26 Thread marius adrian popa
you can play with c++ interface https://github.com/FirebirdSQL/firebird/tree/master/examples/interfaces On Tue, Apr 26, 2016 at 1:55 PM, Treeve Jelbert wrote: > some time ago it was stated that the future of IBPP would be decided in > a fwe days. > > I am about to start project using C++ and fi

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

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

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

2016-04-26 Thread 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 es

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

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

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

2016-04-26 Thread 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 acces

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

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

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

2016-04-26 Thread Michal Kubecek
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

Re: [Firebird-devel] IBPP or what?

2016-04-26 Thread Dimitry Sibiryakov
26.04.2016 12:55, Treeve Jelbert wrote: > some time ago it was stated that the future of IBPP would be decided in > a fwe days. IBPP is a completely separate project. It has no connections to Firebird. > I am about to start project using C++ and firebird3. > What interface should I use? I,

[Firebird-devel] IBPP or what?

2016-04-26 Thread Treeve Jelbert
some time ago it was stated that the future of IBPP would be decided in a fwe days. I am about to start project using C++ and firebird3. What interface should I use? Regards, Treeve -- Find and fix application performan

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

2016-04-26 Thread 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 a

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

2016-04-26 Thread 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 goo

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

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

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

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