Issue Details (XML | Word | Printable)

Key: CORE-1687
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Timo Partanen
Votes: 4
Watchers: 4
Operations

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

Allow bigger cache sizes than 2 GB (16K * 128 K) for x64 builds

Created: 12/Jan/08 05:04 AM   Updated: 12/Nov/09 05:19 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 2.5 RC1

Time Tracking:
Not Specified

Target: 2.5.0


 Description  « Hide
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.

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Smirnoff Serg added a comment - 14/Jan/08 04:47 AM
"Helps much"? Hmm... You thinks that OS file cache is worse than Firebird cache? Some tests you made are prove this?
IMHO OS cache is enough for low disk usage, and my Linux-based classic Firebird tells me that.

Jobin Augustine added a comment - 28/Jan/08 11:52 PM
if Database cache is not better than a file cache provided by OS...then what is the use of Database cache?
do we have a clear benchmark?. if it filesystem cache works fine, it is a good idea to depend on it.
many RDBMS systems like Oracle suffered because of this address space limit.
new 64bit architecture is great relief for them

Vlad Khorsun added a comment - 01/Sep/09 10:29 AM
As 32-bit build anyway can't use more than 2GB memory i will relax cache size limit in 64-bit builds only.

Vlad Khorsun added a comment - 05/Sep/09 11:49 PM
Description changed

Vlad Khorsun added a comment - 05/Sep/09 11:51 PM
In x64 builds max pages buffers limit is 2^31 -1 now