[firebird-support] mapping destroyed by backup / restore

2020-03-08 Thread FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support]
Hi – I have another question re user mapping… If I create a new database with a user->role mapping, I can back up and restore it and the mapping is still present. But if I back up the new copy and restore that, the mapping is gone… is there an issue with the procedure I'm using or is this a

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]
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 can set also in databases.conf and in db file itself by gfix buffers.And it is used in priority.1.

[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