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 bigger cache sizes than 2 GB (16K * 128 K) for x64 builds [CORE1687] #2112
Comments
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Modified by: @dyemanovTarget: 2.5.0 [ 10221 ] |
Commented by: Smirnoff Serg (wildsery) "Helps much"? Hmm... You thinks that OS file cache is worse than Firebird cache? Some tests you made are prove this? |
Modified by: @pcisarWorkflow: jira [ 13814 ] => Firebird [ 14122 ] |
Commented by: Jobin Augustine (jobinau) if Database cache is not better than a file cache provided by OS...then what is the use of Database cache? |
Modified by: @dyemanovstatus: Open [ 1 ] => Open [ 1 ] Fix Version: 2.5 Beta 1 [ 10251 ] Fix Version: 2.5 Alpha 1 [ 10224 ] => |
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] => Vlad Khorsun [ hvlad ] |
Commented by: @hvlad As 32-bit build anyway can't use more than 2GB memory i will relax cache size limit in 64-bit builds only. |
Commented by: @hvlad Description changed |
Modified by: @hvladsummary: Allow bigger cache sizes than 2 GB (16K * 128 K) => Allow bigger cache sizes than 2 GB (16K * 128 K) for x64 builds |
Commented by: @hvlad In x64 builds max pages buffers limit is 2^31 -1 now |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Submitted by: Timo Partanen (partim)
Votes: 4
64-bit Firebird servers should support the caching of big databases (bigger than 2 GB). Currently this is not possible because Firebird cannot benefit from the 64-bit address space. This prevents a database whose size is several gigabytes (e.g. 5 or 10 GB) from totally fitting to the memory and therefore providing the best performance for queries in all cases no matter what data is requested. This feature is important even though Firebird works via the OS file cache which helps much with the caching.
Commits: 1c1dbea
The text was updated successfully, but these errors were encountered: