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
Comments
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. |
Commented by: @hvlad Sean, this was discussed in fb-devel half year ago. |
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). |
Modified by: @pcisarsummary: Allow Firebird to not use filesystem cache for database files => Allow Firebird to not use filesystem cache for database files (on Windows) |
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. |
Modified by: @hvladsummary: Allow Firebird to not use filesystem cache for database files (on Windows) => Allow Firebird to bypass filesystem cache for database files (on Windows) |
Modified by: @pcisarWorkflow: jira [ 12681 ] => Firebird [ 14250 ] |
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
The text was updated successfully, but these errors were encountered: