[Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread liviuslivius
Hi Embarcadero provide in marketing materials comparision about Interbase vs Firebird https://www.embarcadero.com/products/interbase/compare/interbase_firebird and comparision to others https://community.idera.com/developer-tools/b/blog/posts/interbase-isv-database-comparison?utm_source=Eloqua&utm

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Paul Reeves
AFAICT most of the content of that document is rubbish. They have certainly skewed our support costs heavily, using the most extreme examples. The tpc-c performance figures look extremely suspect. Does anyone seriously do tpc-c testing with 2 warehouses? It doesn't make sense to me. Looking at

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Dimitry Sibiryakov
26.02.2020 13:46, Paul Reeves wrote: If anyone can let me have a copy of InterBase XE7 I would be happy to run some proper comparisons on our test rig. Developers Edition is free to download from Embarcadero web site: https://www.embarcadero.com/products/interbase/developer/free-download

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Alex Peshkoff via Firebird-devel
On 2020-02-26 15:46, Paul Reeves wrote: AFAICT most of the content of that document is rubbish. They have certainly skewed our support costs heavily, using the most extreme examples. It's also unclear what point version of FB3 was used - 3.0.0 or something newer like 3.0.4. I'm sure they give

[Firebird-devel] Firebird UDF compiled with Lazarus 2.0.0 and FPC 3.0.4

2020-02-26 Thread Massimo Fazzolari
Hi, I compiled a Firebird UDF library written in object pascal. It works perfectly well on Windows. On Linux I get this error: SQL> select SIMPLE('test') from client; Statement failed, SQLSTATE = 08006 Error reading data from the connection. Firebird Version: Classic 2.5.9.27139-0 Lazarus Versi

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Dimitry Sibiryakov
26.02.2020 14:28, Alex Peshkoff via Firebird-devel wrote: What will be very interesting re journalling - compare interbase with journalling and async writes vs. interbase without journalling and sync writes. This can give us an idea what effect does journalling give. Or compare Interbase+jou

Re: [Firebird-devel] Firebird UDF compiled with Lazarus 2.0.0 and FPC 3.0.4

2020-02-26 Thread Dimitry Sibiryakov
26.02.2020 14:30, Massimo Fazzolari wrote: On Linux I get this error: SQL> select SIMPLE('test') from client; Statement failed, SQLSTATE = 08006 Error reading data from the connection. Check firebird.log for error messages. Enable core dumps and analyse them in debugger. -- WBR, SD.

Re: [Firebird-devel] Firebird UDF compiled with Lazarus 2.0.0 and FPC 3.0.4

2020-02-26 Thread Tony Whyman
My guess is that you are using the wrong calling convention for Linux. Note: IBX uses "stdcall" when accessing the Firebird API under Windows, but changes to using "cdecl" under Linux. On 26/02/2020 13:30, Massimo Fazzolari wrote: Hi, I compiled a Firebird UDF library written in object pasca

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Paul Reeves
On Wed, 26 Feb 2020 16:28:38 +0300 Alex Peshkoff via Firebird-devel wrote: > On 2020-02-26 15:46, Paul Reeves wrote: > > AFAICT most of the content of that document is rubbish. They have > > certainly skewed our support costs heavily, using the most extreme > > examples. > > It's also unclear

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Paul Reeves
On Wed, 26 Feb 2020 14:23:32 +0100 Dimitry Sibiryakov wrote: > 26.02.2020 13:46, Paul Reeves wrote: > > If anyone can let me have a copy of InterBase XE7 I would be happy to run > > some proper comparisons on our test rig. > >Developers Edition is free to download from Embarcadero web site

Re: [Firebird-devel] Firebird UDF compiled with Lazarus 2.0.0 and FPC 3.0.4

2020-02-26 Thread Massimo Fazzolari
I am not familiar with Firebird core dumps, I read this article: https://www.ibphoenix.com/resources/documents/development/doc_36 I am running Firebird 2.5 Classic configured with systemd [1] . I changed the .service file to make firebird running as root. I did run the script in /opt/bin/restoreRo

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Leyne, Sean
> What will be very interesting re journalling - compare interbase with > journalling and async writes vs. interbase without journalling and sync > writes. > This can give us an idea what effect does journalling give. Actually in order to be failsafe, journaling would also need to use sync/ful

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Paul Reeves
On Wed, 26 Feb 2020 15:35:16 +0100 I wrote: > The idea of the failsafe comparison is valid but it depends on how they have > configured journalling. Under light load the cost of journalling will > have limited impact as it will almost certainly be cached. The journalling documentation is here. h

Re: [Firebird-devel] Firebird UDF compiled with Lazarus 2.0.0 and FPC 3.0.4

2020-02-26 Thread Dimitry Sibiryakov
26.02.2020 14:58, Tony Whyman wrote: Note: IBX uses "stdcall" when accessing the Firebird API under Windows, but changes to using "cdecl" under Linux. Yes, but UDF always use cdecl on any platform. Besides, he compiled for x86_64 where only one calling convention exists. Something else must

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Dimitry Sibiryakov
26.02.2020 15:39, Paul Reeves wrote: Been there, looked at that :-) AFAICT it is for InterBase 2020 which is only available for Windows at the moment. The tests in the article were done with XE7. And my test rig uses linux. So I need a version of XE7 for linux. It is available at https://cc

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Paul Reeves
On Wed, 26 Feb 2020 16:48:29 +0100 Dimitry Sibiryakov wrote: > 26.02.2020 15:39, Paul Reeves wrote: > > Been there, looked at that :-) > > > > AFAICT it is for InterBase 2020 which is only available for Windows at the > > moment. The tests in the article were done with XE7. And my test rig uses

[Firebird-devel] Firebird project wiki

2020-02-26 Thread Dimitry Sibiryakov
Hello, All. https://github.com/FirebirdSQL/firebird/wiki redirects back to the main page. Is it because wiki is disabled or just empty? -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird project wiki

2020-02-26 Thread Dmitry Yemanov
26.02.2020 20:01, Dimitry Sibiryakov wrote: https://github.com/FirebirdSQL/firebird/wiki redirects back to the main page. Is it because wiki is disabled or just empty? Empty. Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Dmitry Yemanov
26.02.2020 18:00, Paul Reeves wrote: It seems to contain two contradictory statements. On the one hand it says: The journal file I/O is always synchronous and cannot be altered Synchronous from the filesystem POV. Like with FW=ON for Firebird, but applies only to journal files. and in an

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Dmitry Yemanov
26.02.2020 17:35, Paul Reeves wrote: The idea of the failsafe comparison is valid but it depends on how they have configured journalling. The common trick for benchmarking is to set up a very long (practically infinite from the test POV) checkpoint interval. It provides the best possible per

Re: [Firebird-devel] Firebird project wiki

2020-02-26 Thread Mark Rotteveel
On 26-02-2020 18:01, Dimitry Sibiryakov wrote:   Hello, All.   https://github.com/FirebirdSQL/firebird/wiki redirects back to the main page. Is it because wiki is disabled or just empty? Either you aren't logged in, or you don't have sufficient rights to create wiki pages. If I go to that

Re: [Firebird-devel] Firebird project wiki

2020-02-26 Thread Mark Rotteveel
On 26-02-2020 18:04, Dmitry Yemanov wrote: 26.02.2020 20:01, Dimitry Sibiryakov wrote: https://github.com/FirebirdSQL/firebird/wiki redirects back to the main page. Is it because wiki is disabled or just empty? Empty. Do we have plans to start using it? Otherwise I could just disable it.

Re: [Firebird-devel] Firebird project wiki

2020-02-26 Thread Dimitry Sibiryakov
26.02.2020 18:09, Mark Rotteveel wrote: Do we have plans to start using it? Otherwise I could just disable it. It could be useful for tiny changes in pieces of documentation that don't worth creation of a pull request into the main tree. For example, I've found that a line in OO API descri

Re: [Firebird-devel] Firebird project wiki

2020-02-26 Thread Mark Rotteveel
On 26-02-2020 18:20, Dimitry Sibiryakov wrote: 26.02.2020 18:09, Mark Rotteveel wrote: Do we have plans to start using it? Otherwise I could just disable it.   It could be useful for tiny changes in pieces of documentation that don't worth creation of a pull request into the main tree.   Fo

Re: [Firebird-devel] Firebird project wiki

2020-02-26 Thread Dimitry Sibiryakov
26.02.2020 18:24, Mark Rotteveel wrote: If there already is documentation, and that documentation is not quite correct, that documentation should be fixed instead of creating an erratum elsewhere. I wouldn't call this file "a documentation". It is too brief for that. And because it is so b