Sean,
the difference may also arise from the difference it the test methodology.
We've tried to test a real-world case, so we ran the tests over LAN like a
client-server application (as we know the use of the network interface has also
slowed down).
Otherwise the test logic is simple:
- we have a databases filled up some test data
- at every test we
- start one or two (e.g. lock test) transaction(s)
- prepare some test data if needed (insert new data, update the
existing one, or sometimes delete, or leave the database as is)
- run the business logic (insert/update data (sometimes over views) or
run stored procedures)
- check the expected result (compare table lines, or sp's resultset)
- end at the and the test system DOES ROLLBACK (this is a very stange point,
not a "normal" usage, but we count on the starting database at next time...)
I'm 100% sure this is not a general test procedure, which maybe was run on
PostgreSQL.
András
-----Original Message-----
From: Leyne, Sean [mailto:s...@broadviewsoftware.com]
Sent: Wednesday, January 10, 2018 4:26 PM
To: For discussion among Firebird Developers
<firebird-devel@lists.sourceforge.net>
Subject: Re: [Firebird-devel] Meltdown and Spectre
András,
> -----Original Message-----
> From: Omacht András [mailto:aoma...@mve.hu]
> Sent: Wednesday, January 10, 2018 9:08 AM
> finally we choose the easiest way, backup the system and update it to
> Debian SID.
>
> # uname -a
> Linux firebirdtest 4.14.0-3-amd64 #1 SMP Debian 4.14.12-2 (2018-01-06)
> x86_64 GNU/Linux
>
> Average running time: 641 secs (10 mins 41 secs)
> > Average running time on 4.9.0-4: 466 secs (7 mins 46 secs) Average
> > running time on 4.9.0-5: 635 secs (10 mins 35 secs)
Thanks for re-running your tests.
It is most interesting that FB's post-patch numbers show a much larger impact
(~36% slower) than the Postgres results (~24%).
Sean
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most engaging tech
sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web
interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
__________ Information from ESET Mail Security, version of virus signature
database 16713 (20180110) __________
The message was checked by ESET Mail Security.
http://www.eset.com
__________ Information from ESET Mail Security, version of virus signature
database 16714 (20180110) __________
The message was checked by ESET Mail Security.
http://www.eset.com
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
