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,
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
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
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
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
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
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
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
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
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
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
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
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
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)
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() {
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
;;
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
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
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
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
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
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
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
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
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)
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.
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
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
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
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
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
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
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
{
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,
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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)
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
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
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
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
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 -
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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,
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
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
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 - 100 of 158 matches
Mail list logo