Contact Us | Site Map
Firebird is used by approximately 1 million of software developers worldwide. High compatibility with industry standards on many fronts makes Firebird the obvious choice for developing interoperable applications for homogeneous and hybrid environments.
News & Events
August 30, 2016
The year will be the strong section inside Firebird Conference devoted to Firebird performance. The talks announced below will be devoted to the most popular questions regarding Firebird performance.

Firebird and disk I/O, Dmitry Yemanov, lead Firebird developer
Disk access is the most expensive operation in any database and RDBMS vendors use a lot of tricks to get most of this area. Providing durability ("D" in ACID) is especially important as it introduces an obvious conflict between reliability and performance. This session describes various durability aspects at three different levels — Firebird, operating system and storage hardware — and explains how they interact with each other, what tuning options are effective and how to balance between them. We'll talk about forced writes, OS-level caching, journaling, filesystem barriers, etc.

Diagnosing and fixing Firebird performance problems, by Alexey Kovyazin, IBSurgeon
The question «how to find and eliminate performance problems in Firebird» is important for all database developers.  Firebird offers the number of tools and APIs to answer the question: transaction markers, MON$ tables, TraceAPI, databases and queries performance statistics, and this session will describe how to find the exact reason of slowness in the particular database. We will consider the practical examples of problems and appropriate fixes, based on real-life logs from the production Firebird databases.

Firebird performance comparisons, by Paul Reeves, IBPhoenix
This session will provide performance comparisons between Firebird 3 and Firebird 2.5 using a test harness based upon TPC-C. The data is derived from hours of testing covering different hardware and software configurations taking into consideration things like Server Architecture, Memory, Database size, HDD/SSD etc This should enable us to build a full picture of the impact of how a single configuration change can affect overall performance. Some of the questions this session will answer: does the improved multi-threading in Firebird 3 bring benefits under heavy load? Is SuperClassic still relevant? What is the penalty for using network compression and encryption? Does database encryption sacrifice speed for security?

More performance sessions will be announced in the next weeks too... But there is only 1 day left to register for Firebird Conference 2016 with the Early Bird discount. Hurry up and register today!
August 29, 2016
Jiri Cincura announces the 5.1.0.0 Release of ADO.NET provider for Firebird.

Notable changes or improvements are support for new fields in MON$ATTACHMENTS and support for “-skip_data” in backup/restore. And finally some nice simple performance tweak around Charset class.

Overview of changes can be found in tracker.

You can download them in the ".NET Provider" section of Downloads. Enjoy!
August 26, 2016
We continue to publish announces of talks at Firebird Conference 2016, which will take place in Prague, Czech Republic, October 7-8 (only 1 week left to register to Firebird Conference 2016 with Early Bird discount!). Today we announce the talks from Jiri Cincura, developer of Firebird .NET driver and Firebird+.NET development trainer.

How to implement the full-text search using only PSQL
Firebird at the moment does not have a native support for the full-text search. So you are either out of luck or you have to use syntax using the LIKE or CONTAINING expressions. Luckily when lowering the bar a little (what features the search has to cover) and focusing on core functionality, it is possible to create the very fast full-text search using only fairly simple PSQL and some out-of-the-box thinking. Production examples will be included.

What's new in Firebird.NET Provider
With the release of Firebird 3.0 a lot has changed in .NET provider. Some features from Firebird 3 are already supported now and also a lot of changes and improvements in other areas have been done. This session will walk you through most of these improvements and changes and will show you how to use these and show how these work in Firebird and how you can benefit from using them.
August 07, 2016
Home About Firebird Documentation Downloads Community Support Development Case Studies Back to Top
This site and the pages contained within are Copyright © 2000-2016, Firebird Project. Firebird® is a registered trademark of Firebird Foundation Incorporated. Developed by DQ Team.