23 More Ways To Speed Up Firebird

Why "23 more"?

Some of you remember the article «45 Ways To Speed Up Firebird», which was published in May 2016. Now it is time to publish the next series of tips and tricks, mostly based on the experience of optimization and maintenance of the Firebird databases and servers with a high number of connections (1000+).

1. Set Power Options to High Performance in Windows Server 2016 and 2019

By default, Windows Server has a power plan set to "Balanced", which is not suitable for database servers. Set it to "High Performance" and gain approximately +20% of the performance for CPU-intensive operations. It can be set online, without restart or reboot. The picture below shows the CPU graph, which demonstrates the advantage of "High-performance" power plan: