Subject Re: [firebird-support] Converting to firebird 3
Author Carlos H. Cantu
Post date 2017-10-11T18:26:34Z
Re: [firebird-support] Converting to firebird 3 Firebird 3 may improve your performance, but this is not 100% guaranteed. It depends on several factors. If you have multi-core server and one (or just a few databases), you will benefit from using SuperServer on FB 3.

But, there are some reported problems with some queries where the optimizer is not choosing a good plan (while the same query in FB 2.5 gives a good plan).

When the slides of the currently "Firebird Optimization Tour" becomes publicly available, you will see some interesting situations regarding FB 2.5 x FB 3 performance comparisons.

Also, if you have C/S apps accessing remote servers over the internet, you will benefit from the new enhancements on the wire protocol.

Anyway, start with FB 3.02 (skip 3.0 and 3.01). I just released an article about things that you should consider when moving to Firebird. I strongly sugest you to read it, and also my Migration Guide to Firebird 3:
https://www.firebirdnews.org/things-to-consider-when-moving-to-firebird-3/

The best thing to do is to test it by yourself, before going into production. If your performance problems are related to bad queries or bad transaction control, FB 3 will not help too much.

[]s
Carlos
Migration Guide to Firebird 3 - https://www.firebirdnews.org/migration-guide-to-firebird-3/
www.firebirdnews.org - www.FireBase.com.br


Hi

We have an application with roughly 20 000 lines of code and have been using firebird 2.5 since the start. We do experience performance problems with 30+ client connections and are thinking of moving to firebird 3.

Is firebird 3 drastically going to improve performance and how immense would the conversion to firebird 3 be?

Thanks
Gian