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

2020-03-03 Thread Holger Klemt
try to use the same ssd and install windows server 2012r2, windows server 2016 or windows server 2019 and try it again and you will see what i talk about Mit freundlichen Grüßen / Kind regards Holger Klemt Am 03.03.2020 um 14:10 schrieb Carlos H. Cantu: Re: [Firebird-devel] Interbase vs

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

2020-03-03 Thread Carlos H. Cantu
Title: Re: [Firebird-devel] Interbase vs Firebird by Embarcadero Hi Holger, I got curious on this: "Using nvme ssds on windows server OS without proper driver support always results in very poor performance" I have Samsung EVO nvme ssd in my Windows 10 development machine and never n

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

2020-03-02 Thread Holger Klemt
Sean, on the machine i tested it and in the config i tested based on what i was able to find from their description to have a similar test environment, yes, the resulting number that was reported  in the test was more or less the same for both platforms, but i expect, that this was more or less

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

2020-03-02 Thread Leyne, Sean
Holger, Please clarify > i had discusses their benchmark results already with a embarcadero > employee in a german forum and they insisted that tpc was bad > with firebird  and good with interbase. > > When i reproduced their description of the test on a known powerful firebird > machine and ex

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

2020-03-02 Thread liviuslivius
All my experience is same, FB is better then Interbase. FB miss some features available in Interbase but Interbase miss so many features available in FB then + is for FB.I only cannot accept that you say same about Delphi. It is something totally different.It is for me personally the best progra

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

2020-03-02 Thread Holger Klemt
i had discusses their benchmark results already with a embarcadero employee in a german forum and they insisted that tpc was bad with firebird  and good with interbase. When i reproduced their description of the test on a known powerful firebird machine and exactly the same hardware and same OS

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

2020-02-28 Thread liviuslivius
>>>It is available at https://cc.embarcadero.com/item/30771 but I have no >>> idea if you can get license for it now. >>> >>> >>That link is only for existing, registered, users. >>Paul try this one https://cc.embarcadero.com/Item/30065 you must register - but this is free trial no paid lic

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] 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

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 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] 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 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] 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 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] 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

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 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

[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