News

HQbird 2024R2 Update 13

This is a focused minor release built around a single major feature: the ability to create indices concurrently in Firebird 5.

Many database administrators have lost sleep creating indices at night to avoid impacting production. In some cases, a CREATE INDEX or ALTER INDEX operation running during production hours has caused databases to become unresponsive.

With Firebird in HQbird starting from 5.0.5.1838, this is no longer necessary. The new CREATE INDEX CONCURRENTLY command allows indices to be created without blocking database operations. It is important to add that database is 100% compatble with vanilla Firebird, no need to backup-restore to switch between HQbird and Firebird.
This feature will be available in vanilla Firebird 6, when it will be released, and already available in HQbird.

This release also includes additional improvements and bug fixes, including enhancements to silent installation and uninstallation.

More details: https://ib-aid.com/articles/concurrent-index-creation-in-firebird

Download HQbird: https://ib-aid.com/en/download-hqbird