Subject | Firebird 3 performance |
---|---|
Author | Gert Scholten | Syntri ERP B.V. |
Post date | 2016-07-28T08:31:37Z |
Hello,
I've got a question about the Firebird 3 performance. I've created a test
application which does the following:
FB 2.5.5 (Superclassic)
FB 3.0 (Superserver)
1.000.000 inserts
27 sec
47 sec
# of connections in 30 sec
~1800 connections
~1300 connections
Concurent reads 50 threads 100/queries / thread - average query time
1,35 ms
2,45 ms
Firbebird is installed local as 64-bit service. The database is on an SSD.
I was under the impression that the results should be the other way around.
Ergo, Firebird 3.0 should be a lot faster.
Am I doing something wrong?
Met vriendelijke groet,
E.G. (Gert) Scholten
Technisch Manager
Projectleider
+ 31 (0)528 82 00 55 (T)
+ 31 (0)528 82 00 59 (F)
04086914 (KvK)
Elbe 2
7908 HB Hoogeveen
<mailto:e.g.scholten@...> e.g.scholten@... (E)
<http://www.syntri.nl/> www.syntri.nl (I)
[Non-text portions of this message have been removed]
I've got a question about the Firebird 3 performance. I've created a test
application which does the following:
FB 2.5.5 (Superclassic)
FB 3.0 (Superserver)
1.000.000 inserts
27 sec
47 sec
# of connections in 30 sec
~1800 connections
~1300 connections
Concurent reads 50 threads 100/queries / thread - average query time
1,35 ms
2,45 ms
Firbebird is installed local as 64-bit service. The database is on an SSD.
I was under the impression that the results should be the other way around.
Ergo, Firebird 3.0 should be a lot faster.
Am I doing something wrong?
Met vriendelijke groet,
E.G. (Gert) Scholten
Technisch Manager
Projectleider
+ 31 (0)528 82 00 55 (T)
+ 31 (0)528 82 00 59 (F)
04086914 (KvK)
Elbe 2
7908 HB Hoogeveen
<mailto:e.g.scholten@...> e.g.scholten@... (E)
<http://www.syntri.nl/> www.syntri.nl (I)
[Non-text portions of this message have been removed]