On 4-1-2015 09:48, Alex Peshkoff wrote: > 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.
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. 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
