How to optimize Firebird 3?

1

Does anyone who works with Firebird 3 know exactly how to optimize the SGDB to be more efficient? So far I have done some tests with Firebird 2.5 and 3 to compare queries, and basically it continues the same thing.

Update I realized that optimization from version 2.5 to 3.0 was more about the issue of remote banks, where there is compression.

    
asked by anonymous 22.06.2017 / 19:43

2 answers

3

There are some general and basic rules for better database performance, here you can check them, specifically from 37 onwards for FireBird. Logo:

  • Use pooled connections if they are small and fast
  • Use the Linger in Firebird 3
  • Use JOIN with Hash
  • Tag functions deterministic

  • Use analytical functions

  • Do not use SRP authentication if not required
  • Prefer the function call instead of UDF's
22.06.2017 / 19:57
1

You have a list of performance tips for the Firebird database in different areas - from hardware / operating system, tuning from Firebird configuration to SQL optimization recommendations. This list is not a complete reference on how to optimize Firebird, and assumes you have the basics of the DBMS operation, such as execution plans, transaction management, and query performance statistics.

These tips are on link

    
03.07.2017 / 14:39