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 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!
October 19, 2018
Firebird Performance Tour 2019 will take place in Moscow (November 29, 2018), Prague (December 4, 2018) and Bad Sassendorf, Germany (December 6, 2018).

Firebird Performance Tour will be devoted to the complex parts of SQL queries optimizations and their monitoring:
  1. New features in Firebird 4 — Dmitry Yemanov, Firebird core developer
  2. Explained SQL plans in Firebird 3 and 4 — Dmitry Kuzmenko, IBSurgeon
  3. Understanding Firebird JOINs — Dmitry Yemanov, Firebird core developer
  4. Monitoring of SQL queries in Firebird — Alexey Kovyazin, IBSurgeon
  5. How to optimize heavy SQL queries with GROUP BY/ORDER BY — Dmitry Kuzmenko, IBSurgeon
  6. Clustering: On the road from Master-Slave to Master-Master — Dmitry Yemanov, Alexey Kovyazin
  7. Bonus: New Tips and Tricks To Speed Up Firebird database — Alexey Kovyazin, IBSurgeon
More Details and Registration
Firebird Performance Tour 2019 will take place in Moscow (November 29, 2018), Prague (December 4, 2018) and Bad Sassendorf, Germany (December 6, 2018).

Firebird Performance Tour will be devoted to the complex parts of SQL queries optimizations and their monitoring:
  1. New features in Firebird 4 — Dmitry Yemanov, Firebird core developer
  2. Explained SQL plans in Firebird 3 and 4 — Dmitry Kuzmenko, IBSurgeon
  3. Understanding Firebird JOINs — Dmitry Yemanov, Firebird core developer
  4. Monitoring of SQL queries in Firebird — Alexey Kovyazin, IBSurgeon
  5. How to optimize heavy SQL queries with GROUP BY/ORDER BY — Dmitry Kuzmenko, IBSurgeon
  6. Clustering: On the road from Master-Slave to Master-Master — Dmitry Yemanov, Alexey Kovyazin
  7. Bonus: New Tips and Tricks To Speed Up Firebird database — Alexey Kovyazin, IBSurgeon
More Details and Registration
October 04, 2018
Firebird Project is happy to announce general availability of Firebird 3.0.4 — the 4th point release in the Firebird 3.0 series.

This sub-release offers many bug fixes and also adds a few improvements, please refer to the Release Notes for the full list of changes. Binary kits for Windows, Linux and Android platforms are immediately available for download, Mac OS kits will follow shortly.
Firebird Project is happy to announce general availability of Firebird 3.0.4 — the 4th point release in the Firebird 3.0 series.

This sub-release offers many bug fixes and also adds a few improvements, please refer to the Release Notes for the full list of changes. Binary kits for Windows, Linux and Android platforms are immediately available for download, Mac OS kits will follow shortly.
September 07, 2018