Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Allow Firebird to bypass filesystem cache for database files (on Windows) [CORE1381] #1799

Closed
firebird-automations opened this issue Jul 25, 2007 · 10 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @hvlad

Relate to CORE1480

Firebird may be configured to use large own page buffers cache. In such case filesystem cache will duplicate Firebird's one and give no or small benefit on file reads wasting memory for double caching. It still helps on file writes but only if Forced Writes setting is OFF which is not recommended in most cases.

Proposition is to allow Firebird to not use filesystem cache to free more memory for another operations such as sorting and\or caching of another database etc

Commits: 61427ef b85636a 6cd3900

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

Aren't we trying to get too smart.

Afterall, if the OS wants to cache the file (for read accesses) why would we care. The OS will release the file cache as required, when processes request the memory.

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Sean, this was discussed in fb-devel half year ago.
If you want to continue discussion, please, do it in fb-devel to not lose already pointed arguments

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Often, when Windows tries to cache a big file, it moves the FB page cache to the swap, thus causing *a lot* of unnecessary paging. In my practice, if the FB page cache size is set to more than 80% of the available RAM, you're getting big troubles. Of course, I speak about SuperServer only (the OS file cache is *a must* for Classic).

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

summary: Allow Firebird to not use filesystem cache for database files => Allow Firebird to not use filesystem cache for database files (on Windows)

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

This feature was implemented for Windows only. We'll open another related ticket if we'll implement it for other platforms as well.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Open [ 1 ] => Closed [ 6 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Link: This issue relate to CORE1480 [ CORE1480 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

summary: Allow Firebird to not use filesystem cache for database files (on Windows) => Allow Firebird to bypass filesystem cache for database files (on Windows)

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

CORE1480 is for Posix platforms implementation

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 12681 ] => Firebird [ 14250 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants