TPC-R results on Intel quad core
Tsutomu Hayashi did some benchmarks and here are the results with the time in seconds
Intel Core2Quad 9550 with 4G Memory Firebird Protocol: LocalConnection
All Firebird is defalt settings FB-2.1.2 is very slow, FB-2.5 is fastest.
DBcreation (Seconds – Lower is Better)
FirebirdSS-1.5.5 3007
FirebirdSS-2.1.2 1651
FirebirdSS-2.5Beta2 1289
TPC-R (Seconds – Lower is Better)
FirebirdSS-1.5.5 621
FirebirdSS-2.1.2 2748
FirebirdSS-2.5Beta2 526
(4 votes, average: 4.25 out of 5)
Loading...
I guess he wants to say that FB 1.5 is very slow, not 2.1.
It is strange, but TCP-R test shows that Firebird 2.1 is very slow.
Dimitry Yemanov explains why 2.1 is so slow with the statistics
http://www.nabble.com/TPC-R-3.sql-can%27t-complete-with-FB-2.1.2-to25747923.html#a25833814
“Also, the original tests from IBSurgeon are not good, as IIRC they have
zero statistics for PK and FK indices (constraints are created before
loading the data and index statistics is never updated afterwards) which
badly affects the v2.x optimizer.
Try updating the statistics and v2.1 will perform better than v1.5. “
Hi mariuz
I recomputed all statistics before executing tests. if no recomputed, FB2.1 can’t finish test3 one or more days. So, Dmitry pointed problem is not all. FB2.1 is not suitable for this test.
Tomneko is Tsutomu Hayashi