Issue Details (XML | Word | Printable)

Key: CORE-6235
Type: Bug Bug
Status: Open Open
Priority: Minor Minor
Assignee: Unassigned
Reporter: Luciano Mendes
Votes: 0
Watchers: 5

If you were logged in you would be able to see more operations.
Firebird Core

Update default firebird.conf settings to better reflect modern average hardware capatabilities

Created: 20/Jan/20 04:31 PM   Updated: 28/Mar/20 02:39 PM
Component/s: Engine
Affects Version/s: 3.0.5
Fix Version/s: None

Windows 10 x64
Firebird (x64)

QA Status: No test

 Description  « Hide
- The Firebird is not using the Optimized Configurations for the average hardware with an average load by Default according to the IB Surgeon company. See:

- The Firebird should use the Optimized Configurations for the average hardware with an average load by Default according to the IB Surgeon company. See:

DefaultDbCachePages = "100K" instead of "2048"
FileSystemCacheThreshold = "2M" instead of "64K"
TempBlockSize = "2M" instead of "1M"
TempCacheLimit = "1000M" instead of "64M"
AuthServer = "Legacy_Auth, Srp, Win_Sspi" instead of "Srp"
AuthClient = "Legacy_Auth, Srp, Win_Sspi" instead of "Srp, Srp256, Win_Sspi, Legacy_Auth"
UserManager = "Legacy_UserManager, Srp" instead of "Srp"
LockMemSize = "15M" instead of "1M"
LockHashSlots = "30011" instead of "8191"

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 20/Jan/20 06:01 PM - edited
The suggested AuthServer and AuthClient configuration are insecure and should definitely not be the default. You should not trade in security for better performance unless you know what you're doing. The performance impact of the extra roundtrips for Srp can be mitigated by using a connection pool.

Dmitry Yemanov added a comment - 20/Jan/20 07:39 PM
What is the rationale behind your expectations? The Firebird project intentionally uses the current defaults because they're suitable for any application, including the embedded ones. And these defaults are being updated every few years to better fit the realities. In turn, IBSurgeon deals with dedicated server installations and supports middle- and high-end databases, hence the other defaults suggested.

Luciano Mendes added a comment - 28/Mar/20 01:50 PM
Hi Dmitry,
Thank you very much for your reply.
I noticed that IBSurgeon updated the conf files and now the HW settings and the number of databases and people who will access these databases are taken into account.

My suggestion is that the FirebirdSQL installer can collect this information during the installation process to define the best configuration:
Amount of system memory (Detected by the Firebird installer)
a) <= 12GB
b) >= 16GB

Questions to ask when installing Firebird:
1) How many databases will be managed?
c) <10
d)> >=10
2) How many users will access the databases?
e) <=150
f) >150
Suggested default configuration based on the responses mentioned above:

Best Regards,

Paul Reeves added a comment - 28/Mar/20 02:39 PM
This is definitely not the business of the installer.
But we could include several different conf files in, say, the examples directory.