Hi Fabian,
Firebird caches only actually used pages.
The small cache means that your application touches the small part of the
database.
--
Regards,
Alexey Kovyazin
IBSurgeon
PS It is difficult and wrong to give you any direct advice without all details
in hands - it can lead to worse performance than with default parameters.
среда, 01 июня 2016г., 04:16 +03:00 от Fabian Ernesto Chocron
[email protected] [firebird-support]
[email protected] :
>
>Hi All
>
>We are having trouble setting up the database cache size on FB 3.0
>running on Windows 2008 R2 64 bits with 32 GB ram.
>
>The problem we have is we cannot get the server to allocate the ram for
>the cache as we intend. With FB 2.54 we had the DB cache set very high,
>close to 1 GB per database, all running in RAM memory. With FB 3.0 we
>read it can allocate much more RAM to the cache, but it appears the
>server is allocating very small amount of Ram when the first user
>connects to the DB, and as we connect more users to the DB the ram
>consumption increases slowly. The setting we are playing with are:
>
>On firebird.conf
>
>FileSystemCacheThreshold = 0
>FileSystemCacheSize = 17179869184 (this is 16 GB - the server has 32 GB
>ram.)
>
>On databases.conf
>
>MyTestDB = c:\Temp\MyDb.fdb
>{
>DefaultDbCachePages = 458752
>}
>
>Any ideas what could be wrong? Or what settings would give us maximum
>RAM usage for the DB cache (we dont want file system cache meaning HDD
>cache, we want to have the DB in RAM for the purpose of reading the DB)
>
>Cheers,
>Fabian
>
>
