Firebird Configuration, episode 3: InlineSortThreshold and details of sortings

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.

To Swap or Not To Swap?

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!

Videos about Firebird Configuration: Episode 2,TempCacheLimit

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.

1-step Linux installation scripts: now for CentOS and Ubuntu

Collection of one-step Firebird installation scripts for Linux distributions. The scripts download necessary libraries, configure OS and download and install Firebird, versions 5.0, 4.0, 3.0, 2.5. The first portion is for CentOS 9, 8, 7 and Ubuntu 24 and 22. More to come!

New version of IBSurgeon Full Text UDR is released

Version 1.3 of free open source UDR library for full text seach queries is released, There were few changes.

Perl extension DBD::Firebird version 1.38 is released

Perl extension DBD::Firebird version 1.38 is released with quite a few changes if you compare with preovious announcement

Firebird SQL Client Library for Kotlin Multiplatform

Practical examples of migration to Firebird 5: databases 1.5Tb and 810Gb

In this video, we explore two case studies of successful migrations involving large Firebird databases, one at 1.5TB and the other at 810GB.

Firebird Camp in Brazil

No dia 11 de maio de 2024, ocorrerá o evento "Firebird Camp" em Frederico Westphalen, RS, Brasil. Este seminário prático é dedicado a aprimorar o desempenho dos bancos de dados Firebird. O evento é organizado pela MQFS e contará com apresentações de Edson Gregorio, CEO da MQFS, e Alexey Kovyazin, CEO da IBSurgeon e Presidente da Fundação Firebird. O seminário será conduzido em português.

Digest of Firebird SQL News for Q1 2024

Digest of Firebird SQL News for Q1 2024