Firebird 5.0.1 introduces several bug fixes and stability improvements, as well as a noteworthy new feature for the database optimizer. The update includes the ability to convert subqueries to ANY/SOME/IN/EXISTS in semi-join operations. By default, this feature is disabled, but it promises great improvements in the speed of complex SQL queries. See in-depth article for all details.
April-June 2024 was pretyy intensive period: read the digest of news and events!
This article concludes our comprehensive overview of Firebird 5 features, with a focus on a groundbreaking addition: the SQL Profiler. This new tool significantly simplifies the process of identifying performance bottlenecks in complex stored procedures and pinpointing SQL code responsible for system slowdowns.
In order to make Firebird installation on Linux flawless and fast, we continue the effort to provide one-step Firebird installation scripts for all popular Linux distrinutions - now for Rocky Linux 8 and 9.
In this video, we explore the InlineSortThreshold parameter, a recent addition to the Firebird configuration that alters the execution plan from SORT to REFETCH. Additionally, we briefly examine the ORDER INDEX plan, and perform comparison of 3 sorting methods in Firebird.
This presentation addresses a common inquiry among Firebird database administrators: should the swap space (paging file) be enabled or disabled for Firebird on Linux or Windows servers? We'll delve into the theoretical aspects, examine recommendations from vendors, and most importantly, analyze statistics from production servers running on both Linux and Windows platforms. Here's a heads-up – swap space is essential; turning it off is not recommended!
In this video, we discuss the TempCacheLimit, a crucial parameter for optimizing the performance of queries that involve extensive sorting operations. This parameter frequently goes unnoticed and remains improperly configured, which we will address in detail.
