The new article with the collection of tips and tricks to improve Firebird database performance: 23 More Ways To Speed Up Firebird. The article is based on the appropriate presentation from “Firebird Performance Tour” seminar.
Why “23 more”?
Some of you can remember the article 45 Ways To Speed Up Firebird, which was published in May 2016. Now it is time for some more tips and tricks, mostly based on the experience of optimization and maintenance of the Firebird databases and servers with the high number of connections (1000+).
dbMigration .NET v10 is a simple, easy and intuitive multiple database migration and data synchronization tool, With it you can easily migrate schema and data to Firebird and vice versa.
(Full support for Firebird 1.5~4.0+)
The printed version of the Migration Guide to Firebird 3 was previously available trough CreateSpace site. Since the recent merge of CreateSpace and Amazon’s Kindle Direct Publishing, the printed book had became unavailable.
I’m glad to announce that the printed version of the Guide (in English) is now available in several Amazon sites around the world. If you prefer to have a physical copy instead of the eBook, you can buy it visiting the Guide’s page.
Os brasileiros podem adquirir a versão impressa (em português) diretamente no site da FireBase.
Ho Ho Ho… One of the Santa’s reindeers told us that we may find a nice Christmas gift in the following days. Firebird 4 Beta 1 should arrive with the replication engine ready for testing! Stay tuned for more news…
IBSurgeon is happy to announce the new release of HQbird – advanced Firebird distribution for enterprises, with the following features: native (high-performance and transactions friendly) master-slave replication, improved performance, advanced performance monitoring, automated backups, proper maintenance.
HQbird is 100% compatible with Firebird, it does not require backup/restore to move between HQbird and community Firebird.
This release includes many new features and improvements:
Advanced support of DDL during the replication
operative and archive logs are created and registered automatically in replication configuration and Cloud Backup jobs
Windows installer has the option to install a replica with pre-configured database instance.
Improved automatic database re-initialization
The Pool of Execute On External connections now is available in Firebird 3.0 (as it was in 2.5) which included to HQbird – greatly increases stability and speed of Execute On External statements. The pool can be reviewed and controlled by SQL commands
New monitoring options:
Performance Summary to see cumulative reads/writes/fetches and SQL Ping to monitor database response
Detailed information about all temporary files in Firebird
Indices statistics job now recalculates all indices in AUTO mode (recommended to set it to run once per week)
Automatic upgrade now is also in Linux installer, as it was in Windows – if you already had HQbird installed, Linux installer will update it correctly without reinstallation
New context variable indicating is it master or replica RDB$GET_CONTEXT(‘SYSTEM’, ‘REPLICA’)
Fixes in the interface: icons, sorting order of graphs, etc