Subject Re: [firebird-support] Re: Is Firebird 3 ready for Production?
Author Ann Harrison
On Wed, May 25, 2016 at 1:11 PM, fabianch@... [firebird-support] <> wrote:

 Now on the flip side, the performance sucks, it is worst than with FB 2.54, and when looking at the task manager on windows it appears only one processor it doing the job, as if the code was not SMP enabled.... very strange. 

One possibility is that you're testing V3.0 SuperServer single user.  In V3.0, Firebird is multi-threaded at the client statement level.  It does not decompose queries and schedule the pieces on different processors.  That means that a full-table scan runs on only one processor.  Two simultaneous full-table scans will run on two processors.  

Good luck,