[firebird-support] How to know if FileSystemCacheThreshold works?
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.
Re: [firebird-support] How to know if FileSystemCacheThreshold works?
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.
Re: [firebird-support] How to know if FileSystemCacheThreshold works?
Thanks for your reply. Unfortunately, RAMMap don't work in Windows 10.
Re: [firebird-support] How to know if FileSystemCacheThreshold works?
Hello, Thanks for the replied. I have downloaded new RAMMap ver 1.52 and it work on Windows 10. On Process tab of RAMMap, firebird.exe took 2,183,484K. On File details tab, database file took 2,603,168K. Does it means, FileCached worked? It if worked, how come, the disk kept spinning when query runs? Thanks & regards, Anto.