[#CORE-1687] Allow bigger cache sizes than 2 GB (16K * 128 K) for x64 builds

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:

[ Permalink | « Hide ]

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.

[ Permalink | « Hide ]

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

[ Permalink | « Hide ]

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.