On Wed, 26 Feb 2020 16:28:38 +0300
Alex Peshkoff via Firebird-devel <firebird-devel@lists.sourceforge.net> 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 what point version of FB3 was used - 3.0.0 or something
> newer like 3.0.4. I'm sure they give different scalability results.
> 
> > 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 the figures for the full table scan it looks as if they have
> > created a 16 warehouse database. This will occupy around 1.5 GB of disc
> > space and can easily be loaded in memory. This in itself has an impact on
> > the quality of the test results.
> >
> > The InterBase tests were done with journaling and async writes compared to
> > Firebird with synchronous writes. We don't know the journalling
> > configuration. We also don't know how long the tests were run for. And
> > neither do we know anything about the speed and latency of disc
> > sub-system. If the run is short then journalling would have minimal
> > overhead and InterBase writes would just be cached while Firebird would
> > write straight to disk. So basically the comparison would be invalid.
> > More realistic performance comparisons would be
> >    o with journalling off and sync vs sync
> >    o journalling off and async vs async  
> 
> Here I can't agree with you. They compare 2 recommended fail-safe
> configurations - IBase with journalling (due to journalling there is no
> need to use sync writes) and firebird with sync writes (we have no other
> way to be fail-safe).

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. So it is quite
possible to create a test which gives the impression that Firebird is slow in
comparison.

Which is why I was suggesting other simple comparisons that are more like for
like.

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

Agreed - that is also a test that be interesting to carry out. Under
a realistic load, of course. 


Paul
-- 

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird
 


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to