Improve tests execution time [DNET988]

[firebird-automations]

Submitted by: @cincuranet

At the moment the full tests suite runs a lot of tests in a lot of configurations. The aim of this task is to simplify this and possibly improve the overall time to run all or subset of tests.

Also there might be places where tests themselves can be made faster.

[firebird-automations]

Modified by: @cincuranet

priority: Major [ 3 ] => Minor [ 4 ]

[firebird-automations]

Commented by: @cincuranet

The matrix looks like this:
FB 2.5, FB 3.0, FB 4.0
Server, Embedded
Compression On/Off
Encryption On/Off
.NET Framework and .NET Core

Especially running the whole set (where applicable) with and without compression times encryption really increases the time. Historically this proved sometimes valuable, because specific problem can be triggered by only one test.

Maybe creating inner and outer loop is now a way to go. Also given the .NET 5 and .NET Core state, maybe explicit .NET Framework run isn't needed anymore.

[firebird-automations]

Modified by: @cincuranet

description: At the moment the full tests suite runs a lot of tests in a lot of configurations. The aim of this task is to simplify this a possibly improve the overall time to run all or subset of tests. => At the moment the full tests suite runs a lot of tests in a lot of configurations. The aim of this task is to simplify this and possibly improve the overall time to run all or subset of tests.

Also there might be places where tests themselves can be made faster.

[firebird-automations]

Modified by: @cincuranet

status: Open [ 1 ] => In Progress [ 3 ]

[firebird-automations]

Modified by: @cincuranet

status: In Progress [ 3 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 8.0.0.0 [ 10970 ]