On 4-1-2015 12:13, Alex Peshkoff wrote: > On 01/04/15 13:59, Mark Rotteveel wrote: >> 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. > > On linux I see no performance difference using 2.5 and 3.0 clients, i.e. > looks like this problem is OS specific. Though must say I have both IPv4 > and IPv6 configured on loopback interface.
My machine also has IPv4 and IPv6, but Firebird 2.5 is - of course - only listening on IPv4. When I previously tested with specifying 127.0.0.1 instead of localhost I found no difference in performance (both took 1 second). However I just tried again with 127.0.0.1 and now it is running in 25-30 milliseconds. I can only assume I entered the wrong property name in the VM arguments for the test runner when running the test earlier (and it was still using localhost). So the problem only occurs when a hostname has both an AAAA (IPv6) and A (IPv4) record. That makes it a little less of a problem, but at minimum it should be addressed in the release notes; or maybe fbclient should have an option to try IPv4 first (if that is possible). 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
