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-issue-importer opened this issue Jul 25, 2007 · 10 comments

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 25, 2007

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.

Loading

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 25, 2007

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

Loading

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 25, 2007

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).

Loading

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 9, 2007

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)

Loading

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 9, 2007

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.

Loading

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 9, 2007

Modified by: @pcisar

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

resolution: Fixed [ 1 ]

Loading

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 26, 2007

Modified by: @hvlad

Link: This issue relate to CORE1480 [ CORE1480 ]

Loading

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 26, 2007

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)

Loading

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 26, 2007

Commented by: @hvlad

CORE1480 is for Posix platforms implementation

Loading

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 28, 2008

Modified by: @pcisar

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

Loading

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

Successfully merging a pull request may close this issue.

None yet
2 participants