Subject Re: [firebird-support] Firebird 3 performance
Author

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 PM
Subject: [firebird-support] Firebird 3 performance

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]




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