Re: [firebird-support] Page buffers & cache threshold

2020-03-10 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
Den 2020-03-08 kl. 23:16, skrev liviuslivius liviusliv...@poczta.onet.pl [firebird-support]: > Hi > > I do not know which rel notes have you read but this one is quite good > about > > https://firebirdsql.org/rlsnotesh/rnfb25-fbconf-fscache.html Yes, that's the one. A few things are unclear to

Re: [firebird-support] Page buffers & cache threshold

2020-03-09 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
HiI do not know which rel notes have you read but this one is quite good abouthttps://firebirdsql.org/rlsnotesh/rnfb25-fbconf-fscache.htmlRegards,Karol Bieniaszewski null

Re: [firebird-support] Page buffers & cache threshold

2020-03-08 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
Den 2020-03-08 kl. 10:45, skrev liviuslivius liviusliv...@poczta.onet.pl [firebird-support]: > About 3 > "DefaultDbCachePages" in firebird.conf is used only at server start. > Then restart is needed. But you have 2 more options and you should > check it maybe you override default. Buffers you

RE: [firebird-support] Page buffers & cache threshold

2020-03-08 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
a: 08.03.2020 10:10 (GMT+01:00) Do: firebird-support@yahoogroups.com Temat: [firebird-support] Page buffers & cache threshold   Hi, Trying to figure out the best settings for my database and app usage. Firebird 3.0.4 SuperServer on virtualized Windows Se

[firebird-support] Page buffers & cache threshold

2020-03-08 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
Hi, Trying to figure out the best settings for my database and app usage. Firebird 3.0.4 SuperServer on virtualized Windows Server 2016 with 40 Gbyte RAM and fast SSD disks (separate disks for OS and DB). Database almost 200 Gbyte. Page size 16k. We can assume that no other heavy work is