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 ----- From: 'Gert Scholten | Syntri ERP B.V.' [email protected] [firebird-support] To: [email protected] 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:[email protected]> [email protected] (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." <[email protected]> ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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
