Re: [firebird-support] How to know if FileSystemCacheThreshold works?

[Alexey Kovyazin a...@ib-aid.com [firebird-support]]

Hello,

Download RAMMap from Sysinternals (Micorosft), and see if database file 
is in list of cached files.

Regards,
Alexey Kovyazin
IBSurgeon

On 22.06.2019 11:42, trsk...@yahoo.com [firebird-support] wrote:

Hi guys,

I have FB 3.04 SS in windows 10.

I have a database with these setting on database.conf

my_dba = C:\Dba\db.fdb
{
    FileSystemCacheThreshold = 393216
    LockMemSize = 16M
    LockHashSlots = 30011
    TempCacheLimit = 2048M
    TempBlockSize = 2M
    FileSystemCacheSize = 50
}

Database page size : 16834
Database pagebuffers : 131072

Size of database file is about 8GB. Total Windows RAM, 16GB, free RAM, 
more than 8GB.

I run the same query via flamerobin about three time, then looked on 
WIndows Task Manager and each time the query was running, the disk 
kept spinning.

Does it means that Firebird's FileSystemCache doesn't works? How to 
know if it works?

Thanks in advance.