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
January 08, 2019
The new article with the collection of tips and tricks to improve Firebird database performance: "23 More Ways To Speed Up Firebird". The article is based on the appropriate presentation from "Firebird Performance Tour" seminar.

Why "23 more"?

Some of you can remember the article "45 Ways To Speed Up Firebird", which was published in May 2016. Now it is time for some more tips and tricks, mostly based on the experience of optimization and maintenance of the Firebird databases and servers with a high number of connections (1000+).
The new article with the collection of tips and tricks to improve Firebird database performance: "23 More Ways To Speed Up Firebird". The article is based on the appropriate presentation from "Firebird Performance Tour" seminar.

Why "23 more"?

Some of you can remember the article "45 Ways To Speed Up Firebird", which was published in May 2016. Now it is time for some more tips and tricks, mostly based on the experience of optimization and maintenance of the Firebird databases and servers with a high number of connections (1000+).
December 25, 2018
Firebird Project wishes you a wonderful and prosperous holiday. Merry Christmas and Happy New Year!
Firebird Project wishes you a wonderful and prosperous holiday. Merry Christmas and Happy New Year!
November 02, 2018
Jiri Cincura announces the 6.4.0.0 Release of ADO.NET provider for Firebird.

Among regular bug fixes and improvements he talks about one performance improvement done in this version:
" When the providers talks to the server there’s a lot of numbers read. And all these numbers are coming as 4 bytes (for 32-bit integers), hence 4 bytes buffer is needed. But it would make sense to reuse it, right? And that’s exactly what has been done. The buffer is kept in memory and being reused for Int32s and Int64s. To measure the impact I did fairly synthetic test of fetching 200k rows with just one number column and the Gen0 allocations went down from 41000 to 22500 and allocated memory from ~124MB to ~68MB. I think that’s worth having 8 bytes “dangling” in the memory. 😎"

Overview of all the changes can be found in tracker.

You can download them in the ".NET Provider" section of Downloads. Enjoy!
Jiri Cincura announces the 6.4.0.0 Release of ADO.NET provider for Firebird.

Among regular bug fixes and improvements he talks about one performance improvement done in this version:
" When the providers talks to the server there’s a lot of numbers read. And all these numbers are coming as 4 bytes (for 32-bit integers), hence 4 bytes buffer is needed. But it would make sense to reuse it, right? And that’s exactly what has been done. The buffer is kept in memory and being reused for Int32s and Int64s. To measure the impact I did fairly synthetic test of fetching 200k rows with just one number column and the Gen0 allocations went down from 41000 to 22500 and allocated memory from ~124MB to ~68MB. I think that’s worth having 8 bytes “dangling” in the memory. 😎"

Overview of all the changes can be found in tracker.

You can download them in the ".NET Provider" section of Downloads. Enjoy!
September 07, 2018