Subject | Re: [firebird-support] Firebird 3 performance |
---|---|
Author | |
Post date | 2016-07-28T14:21:24Z |
Hello
It is my understanding that the difference in
performance is not as in previous versions because the server model has been
changed to have multiple processors to attend to multiple requests, however each
request is only served by one processor. In other words the FB3 server can
assign each request to a different processor on demand, but the bottle neck
remains being the hard drive, the memory, the semaphores when a parallel process
is locking up some resource, etc. Having said all that, it is true that in
theory one would imagine that comparing clasic server 2.5 (a model that assigns
an independent process per connection) should compare similar in performance to
FB3 with a upper hand towards FB3 because it shares the memory (cache) and fb2.5
classic does not share cache and hence each instance ends up re-reading the same
data when reading the same data.
Cheers,
Fabian
----- Original Message -----Sent: Thursday, July 28, 2016 6:31 PMSubject: [firebird-support] Firebird 3 performanceHello,
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]
------------------------------------
Posted by: "Gert Scholten | Syntri ERP B.V." <e.g.scholten@...>
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-digest@yahoogroups.com
firebird-support-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/