Eduardo. You problem only will be solved by turning on write cache if possible or switching to a new cache write enabled server. Dot.
Do not change anything in your software.

Em 30/12/2015 12:15, "Eduardo gusedum@... [firebird-support]" <firebird-support@yahoogroups.com> escreveu:

 

I read that disabling forced writes is not safe.

But there is something that I really don´t understand.

If I disable forced writes, then when I make commits, data goes to the RAM of the server and afterwards, in some moment, the data will be physically written to the database.

If I enable disk write cache, then things happen the same way. So, what is the difference?

From what I read, I think the difference is that with disk write cache, Windows manages when to physically write the data but, when disabling forced writes it is not guaranteed that Windows will physically write the data. Is this true?

Another question. Why is so different the performance with disk write cache enabled or disabled? Is this something that happens in every RDBMS or is just a Firebird problem?

Regards

Eduardo

-------- Mensaje original --------
Asunto: Re: [firebird-support] Bad performance of Firebird in Windows Server 2012
De: Ann Harrison aharrison@... [firebird-support] <firebird-support@yahoogroups.com>
Para: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com>
Fecha: 29/12/2015 17:26

 

On Tue, Dec 29, 2015 at 2:44 PM, Macma macma1@... [firebird-support] <firebird-support@yahoogroups.com> wrote:

Do I have to change any configuration or the matter is that if I can´t enable disk cache, there is nothing I can do to improve the performance?

Try to disable force write on that database.

After you have a UPS installed and an aggressive backup schedule.

Good luck,

Ann

Este correo electrónico se ha enviado desde un equipo libre de virus y protegido por Avast. www.avast.com

Este correo electrónico se ha enviado desde un equipo libre de virus y protegido por Avast. www.avast.com