Join Firebird!

Join Firebird Foundation to support Firebird SQL development and receive multiple bonuses

Follow Us

Select your media preference

Newsletter

Subscribe to Firebird’s Newsletter to receive the latest news

News & Events
November 06, 2021

As you know, Firebird Project devotes a lot of effort to QA and performance testing: we have several test servers to run functional and performance tests every day, with results publicly available at www.firebirdtest.com. The official open-source Firebird performance load test, Firebird OLTP-EMUL, is also running as a part of the testing suite, and its results are also available for the public. QA tests confirm that Firebird 4 release has no performance problems, and any such problem during the snapshot phase is addressed and resolved as soon as possible.

Some days ago one of the vendors of management tool for Firebird has disclosed the document with results of Firebird performance testing, which indicates that Firebird 4 performance is worse than Firebird 3. Since it was a public announcement, not an inquiry to the development team, we have decided to do the investigation and publish its results. The investigation team included Vlad Khorsun, Firebird core developer, Pavel Zotov, Firebird QA, and volunteer Alexey Kovyazin from IBSurgeon. 

The result of the test was the following:

wrong performance test results

As you can see, it indicates that Firebird 4 is significantly slower than Firebird 3. These numbers (the measurement units are not important for the understanding) contradict the Firebird QA team results and the experience of leading Firebird providers.

Let’s find out the reason - read the full text of our investigation here.

As you know, Firebird Project devotes a lot of effort to QA and performance testing: we have several test servers to run functional and performance tests every day, with results publicly available at www.firebirdtest.com. The official open-source Firebird performance load test, Firebird OLTP-EMUL, is also running as a part of the testing suite, and its results are also available for the public. QA tests confirm that Firebird 4 release has no performance problems, and any such problem during the snapshot phase is addressed and resolved as soon as possible.

Some days ago one of the vendors of management tool for Firebird has disclosed the document with results of Firebird performance testing, which indicates that Firebird 4 performance is worse than Firebird 3. Since it was a public announcement, not an inquiry to the development team, we have decided to do the investigation and publish its results. The investigation team included Vlad Khorsun, Firebird core developer, Pavel Zotov, Firebird QA, and volunteer Alexey Kovyazin from IBSurgeon. 

The result of the test was the following:

wrong performance test results

As you can see, it indicates that Firebird 4 is significantly slower than Firebird 3. These numbers (the measurement units are not important for the understanding) contradict the Firebird QA team results and the experience of leading Firebird providers.

Let’s find out the reason - read the full text of our investigation here.

October 11, 2021

The English version of the Migration Guide to Firebird 4 (by Carlos H. Cantu) eBook (PDF) is now available to developers and administrators who want to save time and have a smoother migration from an older Firebird version to Firebird 4.

The Guide has 206 pages and covers several topics like Time zones, Read Committed Read Consistency isolation, Replication, Decfloat, etc. A printed version will be made available on Amazon in the near future. Initially available only in Portuguese, it is the result of a successful crowdfunding campaign in Brazil, with the participation of +300 people.

 

The English version of the Migration Guide to Firebird 4 (by Carlos H. Cantu) eBook (PDF) is now available to developers and administrators who want to save time and have a smoother migration from an older Firebird version to Firebird 4.

The Guide has 206 pages and covers several topics like Time zones, Read Committed Read Consistency isolation, Replication, Decfloat, etc. A printed version will be made available on Amazon in the near future. Initially available only in Portuguese, it is the result of a successful crowdfunding campaign in Brazil, with the participation of +300 people.

October 02, 2021

Jaybird 4.0.4 has been released.

The following has been changed since Jaybird 4.0.3:

  • Fixed: ResultSet.updateRow() sets fields to null in result set only (jaybird#37)
  • New feature: Support for NBackup GUID-based backup and in-place restore (jaybird#672)
  • Fixed: Logic error could lead to incorrect logging of "Specified statement was not created by this connection" (jaybird#674)
  • Changed: Updated Firebird 4.0 reserved words based on 4.0.0.2496 (jaybird#597)
  • Fixed: Protocol 15 and 16 had same priority, so Firebird 4.0 might select protocol 15, leading to timeout support not available. (jaybird#676)

Jaybird 4.0.4
Jaybird 4 supports Firebird 2.5 and higher, on Java 7, 8, 11, and 17 (support for Java 17 using the Java 11 version of the driver). See also:

Jaybird 4.0.4 has been released.

The following has been changed since Jaybird 4.0.3:

  • Fixed: ResultSet.updateRow() sets fields to null in result set only (jaybird#37)
  • New feature: Support for NBackup GUID-based backup and in-place restore (jaybird#672)
  • Fixed: Logic error could lead to incorrect logging of "Specified statement was not created by this connection" (jaybird#674)
  • Changed: Updated Firebird 4.0 reserved words based on 4.0.0.2496 (jaybird#597)
  • Fixed: Protocol 15 and 16 had same priority, so Firebird 4.0 might select protocol 15, leading to timeout support not available. (jaybird#676)

Jaybird 4.0.4
Jaybird 4 supports Firebird 2.5 and higher, on Java 7, 8, 11, and 17 (support for Java 17 using the Java 11 version of the driver). See also:

September 14, 2021
June 01, 2021