FirebirdSQL logo

SubQueryConversion

Defines whether IN/ANY/EXISTS sub-queries can be unnested and merged with the outer query using the semi-join algorithm, provided that such a transformation is possible.

Caution

Being en experimental feature, it’s disabled by default.

It can be enabled to benefit from a possibly better performance due to sub-query being evaluated just once and then cached.However, it may also lead to a worse performance in some cases, e.g. when the sub-query returns many rows.Please test with real-world use cases before enabling this conversion in a production environment.

Changed configuration parameters

WireCryptPlugin

A new variant of the ChaCha#20 plugin was added.It uses a 64-bit internal counter rather than 32-bit.The new default value of this parameter is now ChaCha64, ChaCha, Arc4.

cascade_replication

Specifies whether changes applied to the replica database will be also subject of further replication (if any configured).Default value is false (cascading is disabled).