Just a few words about Firebird 3.0 performance.
2016-06-09 10:50:59 GMT
Hello First of all I wanted to say that my post has no intention to diminish the value of new Firebird version. I was in Prague last year on Firebird conference (very nice event BTW) but even then there were doubts how well FB 3 performs in comparision to FB 2.5. As far as I remember there were two presentations with examples regarding perfromance and both were indeterminate - sometimes FB 2.5 behaved better or similar. Few days ago I've decided tu put FB 3.0 under test on a real business application which is working for 24/7. This application is reading data from PostgreSQL database (stored in JSON), parses the data, inserts it to Firebird database and then scans the inserted data and inserts some additional information. (Proccess of scanning the data must be separated from initial inserts). Here are the tests results for 80000 records stored in PostgreSQL. |Test|2.5 CL 1 THR|2.5 CL 4 THR|2.5 SS 1 THR|2.5 SS 4 THR|3.0 CL 1 THR|3.0 CL 4 THR|3.0 SS 1 THR|3.0 SS 4 THR| | Time(s) | 201 | 285 | 169 | 107 | 221 | 321 | 216 | 112 | How to read the tests: 2.5 CL 1 THR - Firebird 2.5, Classic, 1 Thread. 3.0 SS 4 THR - Firebird 3.0, SuperServer, 4 Threads. Tests were performed on 32 bit version and no configration changes has been made with one except: CpuAffinityMask = 255 Tests were made on my dev machine, locally. I've had all unnecessary processes turned off. But these werent a tests made with a "laboratory" precision. However I think you can see here some pattern which may suggest that tests are close to the reality.(Continue reading)