Re: [Firebird-devel] Improve release filenames

2022-08-25 Thread Gabor Boros
2022.08.25. 15:13 keltezéssel, Stefan Heymann írta: I'd like to suggest you use win32 and win64 instead of x86 and x64. Or, it you want to keep the "windows" prefix, use window-32 and windows-64. For me as a Windows user this would be much more logical (the 86 comes from the 80*86 processor,

[Firebird-devel] Release build, snapshot, GitHub CI, AppVeyor

2022-08-22 Thread Gabor Boros
Hi All, Isn't that too much? In Gabor's ideal world..., GitHub CI "from a branch"=snapshot, "from a tag"=release. :-) It's just a technical question from me, not more not less. For example if release and snapshot use the same build infrastructure (compiler, etc.) is good. Or not? :-) (Now

Re: [Firebird-devel] Build master branch with VS 2019

2022-08-19 Thread Gabor Boros
2022.08.19. 14:24 keltezéssel, Mark Rotteveel írta: You can also download snapshots from https://github.com/FirebirdSQL/firebird/actions/workflows/main.yml (e.g. use one built from master) https://github.com/FirebirdSQL/firebird/actions/runs/2889248978#artifacts

Re: [Firebird-devel] Build master branch with VS 2019

2022-08-19 Thread Gabor Boros
2022.08.19. 12:31 keltezéssel, Vlad Khorsun írta:   Here is missed lines about preprocessing of dsql/metd.epp, dsql/DdlNodes.epp and dsql/PackageNodes.epp Check, please, presence of src/dsql/*.epp files r:\firebird-master\src\dsql\DdlNodes.epp r:\firebird-master\src\dsql\metd.epp

Re: [Firebird-devel] Build master branch with VS 2019

2022-08-19 Thread Gabor Boros
2022.08.19. 10:54 keltezéssel, Vlad Khorsun írta:   It shows that preprocessing was failed. Look for the following line at console: Preprocessing the source files needed to build gpre and isql... Few lines after there should be few blocks like: Processing burp/backup.epp Calling GPRE for

Re: [Firebird-devel] Build master branch with VS 2019

2022-08-19 Thread Gabor Boros
2022.07.03. 12:43 keltezéssel, Gabor Boros írta: I tried to build master branch with VS 2019 Community 2019 16.11.16 on an up to date Windows 10 Pro 64bit. At make_boot got fatal errors in isql_x64.log: Same errors with current state of master branch. Any idea? Gabor Firebird-Devel

Re: [Firebird-devel] Roadmap, Planning Board, version of 4.0 snapshots

2022-08-16 Thread Gabor Boros
2022.03.04. 15:04 keltezéssel, Dmitry Yemanov írta: Updated, thanks. 4.0.2 already released but snapshot's version still 4.0.2. 5.0 Alpha not released in June, please update the Planning Board page. Gabor Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Why "affect-version: 4.0.2" and "fix-version: 4.0.3"?

2022-07-11 Thread Gabor Boros
2022.07.07. 17:08 keltezéssel, Adriano dos Santos Fernandes írta: I will fix these labels. The next still have "fix-version: 4.0.3" label. ;-) https://github.com/FirebirdSQL/firebird/issues/7038 Gabor Firebird-Devel mailing list, web interface at

[Firebird-devel] Why "affect-version: 4.0.2" and "fix-version: 4.0.3"?

2022-07-07 Thread Gabor Boros
Hi All, 4.0.2 not released or tagged yet. Why some issues have these labels? https://github.com/FirebirdSQL/firebird/issues?q=label%3A%22affect-version%3A+4.0.2%22+ https://github.com/FirebirdSQL/firebird/issues?q=label%3A%22fix-version%3A+4.0.3%22+ Gabor Firebird-Devel mailing list, web

[Firebird-devel] Build master branch with VS 2019

2022-07-03 Thread Gabor Boros
Hi All, I tried to build master branch with VS 2019 Community 2019 16.11.16 on an up to date Windows 10 Pro 64bit. At make_boot got fatal errors in isql_x64.log: WorkerAttachment.cpp lock.cpp gsec.cpp ppg.cpp nbackup.cpp The command

[Firebird-devel] Version of 3.0 snapshots

2022-06-29 Thread Gabor Boros
Hi All, 3.0.10 already released and the snapshots still show 3.0.10. Please increase the revision number. Thank you! Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Roadmap, Planning Board, version of 4.0 snapshots

2022-03-03 Thread Gabor Boros
Hi All, 3.0.9 already released, please update the Roadmap page. 5.0 Alpha not released in January, please update the Planning Board page. 4.0.1 already released but the snapshot's version still 4.0.1. Thank you! :-) Gabor Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Build and install with a Raspberry Pi 4B

2021-12-13 Thread Gabor Boros
2021.12.13. 18:34 keltezéssel, Alex Peshkoff via Firebird-devel írta: Gabor, please check FB5 installer on aarch64. A. Build 84656f1 from scratch and the installation works as expected. After that connection works from a remote client (before and after rebooted the server too). Gabor

Re: [Firebird-devel] Build and install with a Raspberry Pi 4B

2021-12-11 Thread Gabor Boros
2021.12.11. 19:05 keltezéssel, Alex Peshkoff via Firebird-devel írta: Almost OK - please try this sligntly modified form: #!/bin/sh clear CorrectLibDir() { ld=${1} case $(uname -m) in i686) LDL=ld-linux.so ;; x86_64)

Re: [Firebird-devel] Build and install with a Raspberry Pi 4B

2021-12-10 Thread Gabor Boros
2021.12.10. 12:43 keltezéssel, Alex Peshkoff via Firebird-devel írta: Try such function please: Results of the below script Pi OS 64bit: /lib/aarch64-linux-gnu /lib Debian 11 32bit: /lib/i386-linux-gnu /lib Debian 11 64bit: /lib/x86_64-linux-gnu #!/bin/sh clear CorrectLibDir() {

Re: [Firebird-devel] Build and install with a Raspberry Pi 4B

2021-12-10 Thread Gabor Boros
2021.12.10. 12:43 keltezéssel, Alex Peshkoff via Firebird-devel írta: Try such function please: CorrectLibDir() {     ld=${1}     case $(uname -m) in     i686)     LDL=ld-linux.so.2     ;;     x86_64)     LDL=ld-linux-x86-64.so.2     ;;    

Re: [Firebird-devel] Build and install with a Raspberry Pi 4B

2021-12-09 Thread Gabor Boros
2021.12.08. 18:25 keltezéssel, Gabor Boros írta: 2021.12.08. 17:55 keltezéssel, Alex Peshkoff via Firebird-devel írta: No, sorry. I don't know how, but the bigger problem is I don't know the good solution. Gabor The below script works with aarch64 and x86_64 for me, but with Debian 11

Re: [Firebird-devel] Build and install with a Raspberry Pi 4B

2021-12-08 Thread Gabor Boros
2021.12.08. 17:55 keltezéssel, Alex Peshkoff via Firebird-devel írta: Yep, we need something more generic here. Can you prepare PR? No, sorry. I don't know how, but the bigger problem is I don't know the good solution. Gabor Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Build and install with a Raspberry Pi 4B

2021-12-08 Thread Gabor Boros
2021.12.08. 14:23 keltezéssel, Gabor Boros írta: dirname: hiányzó operandus További információkért adja ki a(z) „dirname --help” parancsot. One problem what I found, the below commit not care about aarch64. Alex? :-) https://github.com/FirebirdSQL/firebird/commit

[Firebird-devel] Build and install with a Raspberry Pi 4B

2021-12-08 Thread Gabor Boros
Hi All, I try to build and install from the master branch with the 64bit version of the official OS (2021-10-30-raspios-bullseye-arm64). ./autogen.sh --prefix=/opt/firebird make After in the gen directory make -f Makefile.install tarfile Then try to install from the extracted tar.gz with

Re: [Firebird-devel] Plans for 3.0.8

2021-12-01 Thread Gabor Boros
2021.11.17. 19:58 keltezéssel, Mark Rotteveel írta: Firebird 3.0.8 has been released: https://firebirdsql.org/en/news/firebird-3-0-8-sub-release-is-available/ Mark Please update the Roadmap page: https://firebirdsql.org/en/roadmap Gabor Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-06 Thread Gabor Boros
2021.11.06. 12:35 keltezéssel, Omacht András írta: Gábor, am I correct? I think yes. But at searching as a user I want to get ZEBRA and ZSIRÁF too if use starting with 'Z'. :-) Gabor Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-05 Thread Gabor Boros
2021.11.05. 12:36 keltezéssel, Pavel Cisar írta: However, the Czech language defines only one contraction (CH), but there are other languages that have many such as Hungarian. Yes: cs, dz, gy, ly, ny, sz, ty, zs and dzs. Sorry. :-) Gabor Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Plans for 3.0.8?

2021-09-09 Thread Gabor Boros
2021.09.09. 18:41 keltezéssel, Slavomir Skopalik írta: And if snapshot has quality of release, why is not released more often officially? +1 Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Plans for 3.0.8?

2021-09-09 Thread Gabor Boros
2021.09.06. 12:45 keltezéssel, Dmitry Yemanov írta: 06.09.2021 13:31, Omacht András wrote: is 3.0.8 expected to be released in the near future? Yes, September-October. Dmitry 3.0.7 released in October 2020. What we need to get more frequent (for example in the middle of each quarter)

[Firebird-devel] RDB$CONFIG

2021-08-03 Thread Gabor Boros
Hi All, Nice idea but this feature useless in current form. The documentation say: "Table RDB$CONFIG is populated from in-memory structures upon request and its instance is preserved for the SQL query lifetime. For security reasons, access to this table is allowed for administrators only.

Re: [Firebird-devel] Slow DDL execution with 4.0 and 3.0

2021-07-11 Thread Gabor Boros
2021.05.20. 10:36 keltezéssel, Gabor Boros írta: Hi All, I try to find why the real life application's internal database version changer much slower with 4.0. One slow step is the procedure altering. Vlad suggested and index privately: RDB$DEPENDENCIES (RDB$DEPENDENT_NAME, RDB

Re: [Firebird-devel] Replication - generators' value are not replicated

2021-06-08 Thread Gabor Boros
2021.06.08. 10:11 keltezéssel, Dmitry Yemanov írta: 08.06.2021 11:03, Gabor Boros wrote: I can send (to who and which address?) a test case privately which demonstrate the problem. The generator's new value used at insert, the new record replicated but the generator's value not. Please send

Re: [Firebird-devel] Replication - generators' value are not replicated

2021-06-08 Thread Gabor Boros
2021.05.18. 13:21 keltezéssel, Dmitry Yemanov írta: This is "as designed". Generators are replicated if you made some modifications and commit them, in other words if you had a chance to store the newly generated values in some tables. Hi Dmitry and All, I can send (to who and which

[Firebird-devel] 4.0 - Slow DDL execution with autonomous transactions

2021-05-27 Thread Gabor Boros
Hi All, I have an fbk, restore with 2.5, 3.0 and 4.0, then execute the next with isql: execute block AS declare variable stmt varchar(200); begin for select 'DROP TRIGGER '||trim(rdb$trigger_name) from rdb$triggers where rdb$system_flag=0 into :stmt do begin in autonomous

[Firebird-devel] Slow DDL execution with 4.0 and 3.0

2021-05-20 Thread Gabor Boros
Hi All, I try to find why the real life application's internal database version changer much slower with 4.0. One slow step is the procedure altering. First, made an isql test case with WIN1250 connection because the real life application use that. The script file alter 2265 procedures in the

Re: [Firebird-devel] 4.0 replication - One primary database with two modes

2021-05-17 Thread Gabor Boros
2021.05.17. 11:31 keltezéssel, Dmitry Yemanov írta: You may specify both sync and async settings inside the same (single) database entry. Dmitry One entry for one database with two modes. Thank you Dmitry! It works! :-) Gabor Firebird-Devel mailing list, web interface at

[Firebird-devel] 4.0 replication - One primary database with two modes

2021-05-17 Thread Gabor Boros
Hi All, With the next configuration only REPLICA_ASYNC.FDB have the changes of ORIGINAL.FDB. database = C:\R\DB\ORIGINAL.FDB { journal_directory = C:\R\JD journal_archive_directory = C:\R\JAD journal_archive_timeout = 10 } database = C:\R\DB\REPLICA_ASYNC.FDB {

Re: [Firebird-devel] Natural plan with rdb$procedures and 3.0, 4.0

2021-05-11 Thread Gabor Boros
2021.05.11. 15:09 keltezéssel, Adriano dos Santos Fernandes írta: Because the index segment is now prefixed with RDB$PACKAGE_NAME. Adriano Nice. And where is the backward compatibility? :-) Why modified the old and not a new index for package+proc names? Gabor Firebird-Devel mailing list,

[Firebird-devel] Natural plan with rdb$procedures and 3.0, 4.0

2021-05-11 Thread Gabor Boros
Hi All, I tried with employee... SQL> select 1 from rdb$procedures where rdb$procedure_name='x'; 2.5.9.27139 PLAN (RDB$PROCEDURES INDEX (RDB$INDEX_21)) 3.0.8.33468 PLAN (RDB$PROCEDURES NATURAL) 4.0.0.2478 PLAN (RDB$PROCEDURES NATURAL) Why? :-) Gabor Firebird-Devel mailing list, web

Re: [Firebird-devel] RDB$USER_PRIVILEGES of 4.0

2021-03-04 Thread Gabor Boros
2021.03.04. 11:49 keltezéssel, Alex Peshkoff via Firebird-devel írta: That are grants to system privileges. Normally they are created using GRANT something TO SYSTEM PRIVILEGE name, but some are predefined in database. If you use this SQL: select distinct RDB$RELATION_NAME, T.RDB$TYPE_NAME

[Firebird-devel] RDB$USER_PRIVILEGES of 4.0

2021-03-04 Thread Gabor Boros
Hi All, In ISQL with a brand new 4.0 database: SQL> select distinct rdb$user, rdb$user_type from rdb$user_privileges where rdb$user not in ('SYSDBA','PUBLIC') order by rdb$user; RDB$USERRDB$USER_TYPE = 22 20 3 20 4

Re: [Firebird-devel] [Firebird-checkins] [FirebirdSQL/firebird] 74f481: Backport of the fix from the master branch: Now CR...

2019-11-27 Thread Gabor Boros
2019. 11. 27. 15:52 keltezéssel, Roman Simakov írta: Backport of the fix from the master branch: Now CREATE FUNCTION/PROCEDURE inside CREATE PACKAGE does not require CREATE FUNCTION/PROCEDURE privilege It's not really necessary since there are no packages in 3.0 but the patch fixes

Re: [Firebird-devel] Plan for releasing Firebird 3.0.5?

2019-11-02 Thread Gabor Boros
2019. 11. 02. 11:17 keltezéssel, Mark Rotteveel írta: It has been over a year since Firebird 3.0.4. What are the plans for releasing 3.0.5? "it's scheduled for Q3 2019" https://firebirdsql.org/en/roadmap Gabor Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Linking re2 and libstdc++ in Linux

2019-08-20 Thread Gabor Boros
2019. 08. 20. 6:23 keltezéssel, Dmitry Kovalenko írta: Hello, RE2 - it is "Resident Evil 2" game? Dmitry Kovalenko. https://github.com/google/re2 Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Build, install and test 3.0 on Debian 10

2019-06-19 Thread Gabor Boros
2019. 06. 19. 17:08 keltezéssel, Alex Peshkoff via Firebird-devel írta: Gabor, please also send me output (rather long - redir to file) of   ldconfig -v -N -X on your system. I sent you to your private address. Gabor Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Build, install and test 3.0 on Debian 10

2019-06-14 Thread Gabor Boros
2019. 06. 14. 15:16 keltezéssel, Alex Peshkoff via Firebird-devel írta: What do ldd isql (in appropriate bin dirs)   and ldd /usr/lib64/libfbclient.so show in both cases? With own build /usr/local/firebird/bin$ ldd isql linux-vdso.so.1 (0x7ffe53561000) libfbclient.so.2

Re: [Firebird-devel] Build, install and test 3.0 on Debian 10

2019-06-14 Thread Gabor Boros
2019. 06. 13. 10:51 keltezéssel, Paul Beach írta: b, is the installer creating it? I see some difference between the two install.sh files. The trivial /opt/firebird vs /usr/local/firebird and two times "if [ "yes" = "yes" ]" vs "if [ "no" = "yes" ]". What is this "if" thing? I hope it's a

Re: [Firebird-devel] Build, install and test 3.0 on Debian 10

2019-06-14 Thread Gabor Boros
2019. 06. 13. 10:51 keltezéssel, Paul Beach írta: a, is there a findable symlink from libfbclient.so.2 to the real name of libfbclient (probably libfbclient.so.3.0.5) b, is the installer creating it? Output of "find / -name "libfbclient*" -type l -ls" with own build 672502 0

Re: [Firebird-devel] Build, install and test 3.0 on Debian 10

2019-06-13 Thread Gabor Boros
2019. 06. 13. 10:51 keltezéssel, Paul Beach írta: a, is there a findable symlink from libfbclient.so.2 to the real name of libfbclient (probably libfbclient.so.3.0.5) b, is the installer creating it? I started from scratch, just in case. After the "make" step the output of "find / -name

Re: [Firebird-devel] Build, install and test 3.0 on Debian 10

2019-06-12 Thread Gabor Boros
2019. 06. 12. 18:57 keltezéssel, Adriano dos Santos Fernandes írta: Probably a problem with libtommath absence or wrong version. I have libtommath (libtommath1 and libtommath-dev 1.1.0-3) installed. Next symlinks exists: libtommath.so, libtommath.so.0, libtommath.so.1. Gabor

[Firebird-devel] Build, install and test 3.0 on Debian 10

2019-06-12 Thread Gabor Boros
Hi All, I try to make and test "my own" build with Debian 10. First with default settings, just execute "autogen.sh", "make" and "make install" without any modification. At the last step I got the next problem: Firebird 3.0.5.33140-0.amd64 Installation Press Enter to start installation or

Re: [Firebird-devel] Snapshots of 4.0

2019-04-30 Thread Gabor Boros
2019. 04. 22. 20:07 keltezéssel, Gabor Boros írta: Yes, 4.0.0.1499 installer works as expected. Thank you! Works (4.0.0.1506) with Debian Testing/Buster/10 too. Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Windows snapshots

2019-04-29 Thread Gabor Boros
2019. 04. 29. 20:02 keltezéssel, Adriano dos Santos Fernandes írta: On 29/04/2019 14:59, Vlad Khorsun wrote:   You may try AppVeyor builds: https://ci.appveyor.com/project/FirebirdSQL/firebird/history Clicking in a build, a job name, then Artifacts... Thank you guys! Gabor

[Firebird-devel] Windows snapshots

2019-04-29 Thread Gabor Boros
Hi All, Windows builds are not fresh. Please fix they. Thanks! Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Snapshots of 4.0

2019-04-22 Thread Gabor Boros
2019. 04. 17. 9:17 keltezéssel, Alex Peshkoff via Firebird-devel írta: Gabor, please try current snapshot - should work. Yes, 4.0.0.1499 installer works as expected. Thank you! Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Snapshots of 4.0

2019-04-04 Thread Gabor Boros
2019. 04. 03. 13:12 keltezéssel, Alex Peshkoff via Firebird-devel írta: Fixed now If try to install on Debian 9.8 got an error message about libtommath.so.0. The installer created a symlink which point to /usr/lib/x86_64-linux-gnu/libtommath.so.1 but its placed into the installer's

[Firebird-devel] Snapshots of 4.0

2019-03-30 Thread Gabor Boros
Hi All, The Windows kits are outdated: http://web.firebirdsql.org/download/snapshot_builds/win/4.0 In the Linux directory I see kits of 3.0: http://web.firebirdsql.org/download/snapshot_builds/linux/fbtrunk Gabor Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] FB4 - Linux snapshots

2019-02-25 Thread Gabor Boros
2018. 12. 03. 11:06 keltezéssel, Alex Peshkoff via Firebird-devel írta: On 12/3/18 12:17 PM, Gabor Boros wrote: Hi All, The current Windows snapshots of 4.0 are 4.0.0.1324 but the Linux just 4.0.0.1258. Please fix/update it. Build fails due to too old (4.8) ICU. IMO it's also time

Re: [Firebird-devel] Latest OLTP results DB size resolved

2019-02-17 Thread Gabor Boros
2019. 02. 14. 21:07 keltezéssel, Karol Bieniaszewski írta: >> Can you execute same SS (2.5 vs 3.0) tests with 5 ISQL sessions? I do not know what purpose for only 5 ISQL but here you are. Thank you very much! Gabor Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Latest OLTP results

2019-02-14 Thread Gabor Boros
2019. 02. 14. 12:34 keltezéssel, liviuslivius írta: Hi 48 sessions Can you execute same SS (2.5 vs 3.0) tests with 5 ISQL sessions? Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Latest OLTP results

2019-02-14 Thread Gabor Boros
2019. 02. 13. 6:44 keltezéssel, Karol Bieniaszewski írta: FB3 SuperServer is the best always. How many ISQL sessions used? Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Welcome back Firebird-checkins!

2019-01-31 Thread Gabor Boros
2019. 01. 31. 12:53 keltezéssel, Adriano dos Santos Fernandes írta: On 31/01/2019 09:41, Gabor Boros wrote: Hi All, I don't know who fixed/resurrected it but... Thank you very much! Much more easier to follow the development with it. The checkins list were running in firebird-check

[Firebird-devel] Welcome back Firebird-checkins!

2019-01-31 Thread Gabor Boros
Hi All, I don't know who fixed/resurrected it but... Thank you very much! Much more easier to follow the development with it. Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ODP: Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Gabor Boros
2019. 01. 24. 13:12 keltezéssel, Karol Bieniaszewski írta: Do you have permanent (dummy) connection to Firebird3 SS database? If not connect to database and then run test. Permanent connection cause to do not clear SuperServer cache. I just start the Firebird server then the ISQL session(s)

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Gabor Boros
2019. 01. 24. 9:50 keltezéssel, Gabor Boros írta: I will execute my ISQL cases with 2.5 SS and 2.5 SC on a real HDD. We will see... - 1 ISQL 1 DB 2.5 SS - 3:03 2.5 SC - 3:08 - 5 ISQL 1 DB 2.5 SS - 11:13 2.5 SC - 7:28 - 5 ISQL 5 DB 2.5 SS - 11:11 2.5 SC - 7:22 Gabor Firebird-Devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5992) Cannot create multiple tables concurrently

2019-01-24 Thread Gabor Boros (JIRA)
Versions: 4.0 Beta 1 Environment: Windows 10 64bit and 4.0.0.1403 SuperServer Reporter: Gabor Boros Attachments: CREATE_TABLE.ZIP Execute CREATE_TABLE.bat (after modify IP, etc. in CREATE_TABLE_X.bat) and two from five ISQL sessions always fail with: Statement failed

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Gabor Boros
2019. 01. 24. 8:27 keltezéssel, Dmitry Yemanov írta: i.e. v3 finally becomes faster than v2.5, but v4 is slower than v3 (while faster than v2.5) Correct? Yes. But 2.5 SC beats them all. I made a graph from the results. The numbers are seconds and the smaller is the better. Gabor

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Gabor Boros
2019. 01. 24. 8:24 keltezéssel, liviuslivius írta: Hi. I have thinked about oltp comparision, and i think that comparing e.g. classic vs superserver on RAM disc is wrong. Why? Because read from "disc" is as fast as read from cache. The comparision can show some problems but results must be

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-23 Thread Gabor Boros
I got a request privately about the 2.5 SuperClassic numbers. The numbers are (with DefaultDbCachePages = 1): The original case: 3:03 - 65.56 MB Same script into 5 databases concurrently: 7:21 Same script with numbered(1..5) table names into one database concurrently: 7:22 -

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-23 Thread Gabor Boros
2019. 01. 21. 17:41 keltezéssel, Dmitry Yemanov írta: 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). Same

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-21 Thread Gabor Boros
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

[Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-19 Thread Gabor Boros
Hi All, I wanted to know how much faster 3.0 is than 2.5 and 4.0 than 3.0. Tried to compare performance of 2.5, 3.0 and 4.0 with Firebird's OLTP solution (executed ~100 times). The results are constant for me. 3.0 is slower than 2.5 and 4.0 is slower than 3.0. (Some numbers published in the

Re: [Firebird-devel] FB4 linux package

2019-01-11 Thread Gabor Boros
2019. 01. 11. 17:54 keltezéssel, Alex Peshkoff via Firebird-devel írta: Once again updated the build, now try with -fabi-version=7 (8 appears too big). This can affect first of all CentOS-7. Also please try on new systems with libtommath.so.1 (not .0). That should be fixed now (symlink should

Re: [Firebird-devel] FB4 linux package

2019-01-10 Thread Gabor Boros
2019. 01. 10. 16:33 keltezéssel, Alex Peshkoff via Firebird-devel írta: Test it's install is once again highly welcome. Successfully installed on Debian 9, 10 and CentOS 7. (Can connect to /opt/firebird/.../employee.fdb from a different (Windows) machine.) Gabor Firebird-Devel mailing

Re: [Firebird-devel] FB4 linux package

2019-01-10 Thread Gabor Boros
2019. 01. 09. 16:27 keltezéssel, Alex Peshkoff via Firebird-devel írta: Hi all! In http://web.firebirdsql.org/download/prerelease/linux_x64/ there is 64-bit linux package of FB4 built using environment planned for 'official' builds (gcc 6.4, glibc 2.17). Please try it with your favorite

Re: [Firebird-devel] FB4 linux package

2019-01-09 Thread Gabor Boros
2019. 01. 09. 16:27 keltezéssel, Alex Peshkoff via Firebird-devel írta: Hi all! In http://web.firebirdsql.org/download/prerelease/linux_x64/ there is 64-bit linux package of FB4 built using environment planned for 'official' builds (gcc 6.4, glibc 2.17). Please try it with your favorite

Re: [Firebird-devel] Some OLTP numbers

2019-01-04 Thread Gabor Boros
2019. 01. 04. 13:38 keltezéssel, Gabor Boros írta: 2019. 01. 03. 16:43 keltezéssel, liviuslivius írta: 17% bigger and the difference grow with time After change 2.5's firebird.conf (DefaultDbCachePages = 262144, TempCacheLimit = 2147483648 and comment out CpuAffinityMask) I got the below

Re: [Firebird-devel] Some OLTP numbers

2019-01-04 Thread Gabor Boros
2019. 01. 03. 16:43 keltezéssel, liviuslivius írta: 17% bigger and the difference grow with time After change 2.5's firebird.conf (DefaultDbCachePages = 262144, TempCacheLimit = 2147483648 and comment out CpuAffinityMask) I got the below numbers. I want to know why 3.0 faster (than 2.5) for

Re: [Firebird-devel] Some OLTP numbers

2019-01-03 Thread Gabor Boros
2019. 01. 03. 16:20 keltezéssel, Leyne, Sean írta: Gabor, Thanks for the numbers. It would have been more appropriate, IMO, to have simply pasted the numbers as text in the body of your message, rather than as image attachments. I am confused by the meaningfulness of the numbers, given that

Re: [Firebird-devel] Some OLTP numbers

2019-01-03 Thread Gabor Boros
2018. 11. 28. 15:44 keltezéssel, liviuslivius írta: i have sent my settings few weeks ago, maybe you have it in the spam folder? I tried your configuration (with one modification: test_time = 10) on Windows 10 and the size of databases: 2.5.9.27125 SC - 2.77GB 3.0.5.33085 SS - 3.25GB

[Firebird-devel] FB4 - Linux snapshots

2018-12-03 Thread Gabor Boros
Hi All, The current Windows snapshots of 4.0 are 4.0.0.1324 but the Linux just 4.0.0.1258. Please fix/update it. Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Some OLTP numbers

2018-11-28 Thread Gabor Boros
2018. 11. 26. 6:10 keltezéssel, liviuslivius írta: I do not know what was your settings. Same as before. But for me, it is more interesting why db size for Fb2.5 is e.g 6GB but for FB3 it is 15GB after test. Because 3.0 is faster for you than the 2.5? Gabor Firebird-Devel mailing

Re: [Firebird-devel] Some OLTP numbers

2018-11-25 Thread Gabor Boros
2018. 10. 22. 15:37 keltezéssel, Gabor Boros írta: 4.0 slower than 3.0 and 3.0 slower than 2.5? More numbers, more fun. Every case executed three times and the chart show the average of AVG_TIMES_PER_MINUTE results. Any comment? Gabor Firebird-Devel mailing list, web interface at https

Re: [Firebird-devel] ODP: ODP: Some OLTP numbers

2018-10-30 Thread Gabor Boros
2018. 10. 30. 6:52 keltezéssel, Karol Bieniaszewski írta: If someone is interested, now i have compared 3 version of Firebird. The results are promissing as FB4 is the fastest, next FB3. The slowest is FB2.5 – no surprise for me in SS. My numbers for settings: MEDIUM_03 5 docs start FW

Re: [Firebird-devel] Some OLTP numbers

2018-10-28 Thread Gabor Boros
2018. 10. 25. 22:08 keltezéssel, Vlad Khorsun írta:   You set DefaultDbCachePages to 65536 and not changed FileSystemCacheThreshold. Thus you completely disabled file system cache. FileSystemCacheThreshold value increased and the 2 hours cycle re-executed. 2.5 still the fastest. Why does

Re: [Firebird-devel] ODP: Some OLTP numbers

2018-10-26 Thread Gabor Boros
2018. 10. 26. 23:58 keltezéssel, Karol Bieniaszewski írta: Where can i find this OLTP stress test software I like to see my numbers https://sourceforge.net/p/firebird/code/HEAD/tree/qa/oltp-emul Gabor Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Gabor Boros
2018. 10. 25. 22:08 keltezéssel, Vlad Khorsun írta:   You set DefaultDbCachePages to 65536 and not changed FileSystemCacheThreshold. Thus you completely disabled file system cache. Sorry. I just followed the OLTP's readme_quick_start.txt which not wrote anything about

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Gabor Boros
2018. 10. 25. 17:52 keltezéssel, liviuslivius írta: I am also interested Regards, Karol Bieniaszewski I sent it to your address. Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Gabor Boros
2018. 10. 25. 17:45 keltezéssel, Vlad Khorsun írta: 25.10.2018 18:37, Gabor Boros пишет: 2018. 10. 25. 16:16 keltezéssel, Vlad Khorsun írta: I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake somewhere?    Could you

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Gabor Boros
2018. 10. 25. 17:44 keltezéssel, Vlad Khorsun írta: 25.10.2018 18:35, Gabor Boros wrote: 2018. 10. 25. 16:06 keltezéssel, Dimitry Sibiryakov írta: 25.10.2018 15:05, Gabor Boros wrote: I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Gabor Boros
2018. 10. 25. 16:16 keltezéssel, Vlad Khorsun írta: I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake somewhere?   Could you provide html reports generated by the test runs ? Yes. Here or in private? Gabor

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Gabor Boros
2018. 10. 25. 16:06 keltezéssel, Dimitry Sibiryakov írta: 25.10.2018 15:05, Gabor Boros wrote: I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake somewhere?   It is kinda expected. How many worker isqls you had

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Gabor Boros
2018. 10. 23. 10:23 keltezéssel, Gabor Boros írta: 2018. 10. 22. 17:31 keltezéssel, Dimitry Sibiryakov írta: 22.10.2018 17:28, Gabor Boros wrote: How long distance is enough for the correct results?    Usually it is run for 2-3 hours at least. The attached numbers come from 1 hour. I

Re: [Firebird-devel] Some OLTP numbers

2018-10-23 Thread Gabor Boros
2018. 10. 22. 17:31 keltezéssel, Dimitry Sibiryakov írta: 22.10.2018 17:28, Gabor Boros wrote: How long distance is enough for the correct results?   Usually it is run for 2-3 hours at least. The attached numbers come from 1 hour. I will try with 2 and 3 hours. Gabor Firebird-Devel

Re: [Firebird-devel] Some OLTP numbers

2018-10-22 Thread Gabor Boros
2018. 10. 22. 19:23 keltezéssel, Vlad Khorsun írta: As for 2.5 - are you sure you test SS ? Yes. Installed from FirebirdSS-2.5.9.27119-0.amd64.tar.gz Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Some OLTP numbers

2018-10-22 Thread Gabor Boros
2018. 10. 22. 15:41 keltezéssel, Dimitry Sibiryakov írta: 22.10.2018 15:37, Gabor Boros wrote: Why the big difference between numbers which result from the same version?   OLTP emul is based on random. It cannot be used as a reliable benchmark on short distances. How long distance

Re: [Firebird-devel] Some OLTP numbers

2018-10-22 Thread Gabor Boros
2018. 10. 22. 16:21 keltezéssel, liviuslivius írta: can you bring some light what that numbers mean? Main results of an OLTP test. https://www.ibphoenix.com/files/conf2014/Firebird-OLTP-Zotov-2014.pdf Gabor Firebird-Devel mailing list, web interface at

[Firebird-devel] Some OLTP numbers

2018-10-22 Thread Gabor Boros
Hi All, After executed an OLTP test with multiple Firebird SS versions got the attached numbers. The test executed three times per Firebird version. Same OLTP configuration, same server (Debian 9.5 64bit) and same client (Windows 10 64bit). The result database deleted and server rebooted

Re: [Firebird-devel] Meltdown and Spectre

2018-10-14 Thread Gabor Boros
2018. 01. 09. 10:52 keltezéssel, Omacht András írta: The database file and the tmp directory located on ramdisk. What was the filesystem of the ramdisk? Tmpfs? Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] FB4 - Linux snapshots

2018-09-21 Thread Gabor Boros
2018. 09. 10. 13:05 keltezéssel, Alex Peshkoff via Firebird-devel írta: On 10.09.2018 12:36, Gabor Boros wrote: Hi All, The available kits are one month old. Please fix the build process. Working on it... Any news? Gabor Firebird-Devel mailing list, web interface at https

Re: [Firebird-devel] FB4 vs CORE-5222

2018-09-19 Thread Gabor Boros
2018. 09. 03. 10:53 keltezéssel, Vlad Khorsun írta:   Issue (a) is fixed now (see above) but issue (b) is hard to fix and i need some time to find if it can be fixed and how to do it. Probably, it should not be fixed at all (hi, Adriano ;)). I going to try this test with execute statement,

[Firebird-devel] FB4 - Linux snapshots

2018-09-10 Thread Gabor Boros
Hi All, The available kits are one month old. Please fix the build process. Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] FB4 vs CORE-5222

2018-08-31 Thread Gabor Boros
Hi All, Now (with 4.0.0.1190) works with one (ISQL) client but got "update conflicts with concurrent update" immediately with two or more clients. Gabor 2018. 08. 23. 17:22 keltezéssel, Gabor Boros írta: Hi All, I tried Thomas' test case (see the link below) with the actua

[Firebird-devel] FB4 vs CORE-5222

2018-08-23 Thread Gabor Boros
Hi All, I tried Thomas' test case (see the link below) with the actual snapshot of 4.0 (4.0.0.1170 SS Win32) and got the next error instantly with one ISQL session. No problem with multiple (5) ISQL sessions if set ReadConsistency to 0. Why the engine not wait for concurrent transactions? I

  1   2   >