How to optimize Firebird 3?

Asked

Viewed 658 times

1

Someone who works with Firebird 3, do you know exactly how to optimize SGDB to be more efficient? So far I’ve run some tests on Firebird 2.5 and 3 to compare queries, and it’s pretty much the same.

Update I realized that optimization of version 2.5 to 3.0 was more in the matter of remote seats, where there is a compression.

delphi firebird

2 answers

3

There are some generic and basic rules for best database performance, here you can check them out specifically from 37 onwards to the Firebird. Soon:

  • Use pool connections if small and fast
  • Use the Linger in Firebird 3
  • Use JOIN with Hash

  • Mark jobsdeterministic

  • Use analytical functions

  • Do not use SRP authentication if not required
  • Prefer function call over UDF’s

1

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

These tips are on the site http://www.firebase.com.br/artigo.php?id=2920

  • 1

    See there on this site there is a lot you can learn to better the performance of FB.

Browser other questions tagged delphi firebird

You are not signed in. Login or sign up in order to post.