Re: [Firebird-devel] ODP: 32-bit builds check
>> Do not know why but 25% of users continue downloading i86 firebird binaries Because they need fbclient.dll in 32 bit version for 32bit projects 32 bit Linux builds?? I can understand for 32 bit Windows applications, but for Linux??? Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] ODP: 32-bit builds check
>> Do not know why but 25% of users continue downloading i86 firebird binaries Because they need fbclient.dll in 32 bit version for 32bit projects Regards, Karol Bieniaszewski Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] 32-bit builds check
Do not know why but 25% of users continue downloading i86 firebird binaries. Therefore we plan to provide 32-bit for fb4 too. Thoughs who can and wish please test http://web.firebirdsql.org/download/prerelease/linux_x86/ This build is not expected to support Centos !!! It was decided to not provide (at least for beta1) binaries for OSes having extremely old toolchain. If we see that we really need such dinosaur binaries we will add them after beta1 as a separate build and will provide 2 sets of binaries. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0
19.01.2019 23:14, Gabor Boros wrote: The ISQL case is. I made a new database (CREATE DATABASE 'R:\DB\INSERT_TEST.FDB' PAGE SIZE 8192;) with 2.5, 3.0 and 4.0. Then execute a one table script on it with ISQL (isql.exe -u SYSDBA -p masterkey 192.168.0.99:R:\DB\INSERT_TEST.FDB -i DATA.sql). Executed this three times per each Firebird version and the numbers are (+/- 1 second): This is a single-threaded test, isn't it? 2.5 - 2:59 - 65.65 MB 3.0 - 3:27 - 68.95 MB 4.0 - 3:37 - 68.95 MB The results are more or less expected in this case (it doesn't mean they're desirable but this is a different story). However, TPC-C and OLTP-EMUL are multi-threaded tests and this is exactly the scenario where v3/v4 are expected to win. Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0
2019. 01. 21. 10:51 keltezéssel, Pavel Cisar írta: Hi, I think that there is enough evidence (provided from various sources, incl. this comparison) that 2.5 is still "significantly" (i.e. not in range that should be ignored) faster than 3.0. If 4.0 is even worse than 3.0, it's another indicator that profiling is needed to identify the problem spots. Rechecked the ISQL case with the recent Win64 SuperServers (2.5.9.27127, 3.0.5.33091, 4.0.0.1388) and got same results (+/- 1-2 seconds). Gabor, do you think that you can create profiling logs from your tests setups? I don't know how and by what tool. If it helps I can send (e.g. upload somewhere) the used script privately (it's just 8.5 MB in 7z format). Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Time zone identifier to displacement convertion
On 21/01/2019 09:21, Alex Peshkoff via Firebird-devel wrote: That means you have old ICU. Should be something like: SQL> select rdb$time_zone_util.database_version() from rdb$database; DATABASE_VERSION 2012j One would hope that it would return a 2018 version at least 2018i was released on the 31st December, but there is no way of ensuring that the data you are using currently will match that which the OS is working with tomorrow! This method of working with timezones was not thought out at all and is why FB4 timezone handling is badly broken! -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - https://lsces.co.uk EnquirySolve - https://enquirysolve.com/ Model Engineers Digital Workshop - https://medw.co.uk Rainbow Digital Media - https://rainbowdigitalmedia.co.uk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Time zone identifier to displacement convertion
On 20/01/2019 20:42, Jorge Gonçalves wrote: > I'm using Firebird-4.0.0.1378-0_x64 and it seems that the timezone > database is missing > > for example the statement > "select rdb$time_zone_util.database_version() from rdb$database;" > > returns > DATABASE_VERSION > > Statement failed, SQLSTATE = HY000 > Error calling ICU's ucal_getTZDataVersion. > -At function 'RDB$TIME_ZONE_UTIL.DATABASE_VERSION' > > The Windows version is still being built with an old ICU version not capable of working with time zones. That update is in process at the moment. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Time zone identifier to displacement convertion
On 1/21/19 1:42 AM, Jorge Gonçalves wrote: I'm using Firebird-4.0.0.1378-0_x64 and it seems that the timezone database is missing for example the statement "select rdb$time_zone_util.database_version() from rdb$database;" returns DATABASE_VERSION Statement failed, SQLSTATE = HY000 Error calling ICU's ucal_getTZDataVersion. -At function 'RDB$TIME_ZONE_UTIL.DATABASE_VERSION' That means you have old ICU. Should be something like: SQL> select rdb$time_zone_util.database_version() from rdb$database; DATABASE_VERSION 2012j Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel