Issue Details (XML | Word | Printable)

Key: CORE-5942
Type: Improvement Improvement
Status: Open Open
Priority: Minor Minor
Assignee: Unassigned
Reporter: Basil A. Sidorov
Votes: 0
Watchers: 4

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

Async write for security#.fdb as default

Created: 15/Oct/18 04:50 PM   Updated: 17/Oct/18 11:35 AM
Component/s: Installation
Affects Version/s: None
Fix Version/s: None

QA Status: No test

 Description  « Hide
Make write asinc for security#.fdb as default option.
Motivation: lowered IO-load for environment with many short-lived connections.

Workaround: change attribute manualy via two restart Firebird server.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Sean Leyne added a comment - 15/Oct/18 04:58 PM
99.9% of access to Security database is reads, so a change to "Forced Writes" setting would have very, very little impact.

Dmitry Yemanov added a comment - 15/Oct/18 08:41 PM
Sean, every "read" (auth check) is performed in a separate transaction and thus modifies at least two pages - header and TIP. However, this shouldn't be an issue starting with 3.0.2, see CORE-5434 (SuperServer only though). So I suppose this topic is either about v2.5 or about Classic. More details are required from the author.

Basil A. Sidorov added a comment - 17/Oct/18 04:51 AM
I'm implement "edge case" - get server version via services from multi-threaded (java) application.
Unexpected result: with "write async" time of test is increased by 10 percent.
I'm take "some time-out".

Basil A. Sidorov added a comment - 17/Oct/18 11:35 AM
"Wrong result - is result also".

security.db = $(dir_secDb)/security3.fdb
RemoteAccess = false
DefaultDbCachePages = 50

If increase DefaultDbCachePages up to security#.fdb size (500 pages or more) disk IO is minimal (3.0SuperServer).

Please clouse ticket or change default for firebird.conf.