| Subject | Re: [firebird-support] Bad performance of Firebird in Windows Server 2012 |
|---|---|
| Author | Eduardo |
| Post date | 2015-12-30T14:15:05Z |
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
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
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:
Try to disable force write on that database.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?
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