I know, but that's impossible to do on that server. So the only solution
I found so far is to install the application in another computer.
But anyway I would like to understand why this is necessary in Firebird.
It would be great if anybody knows the answers to my questions of my
previous message.
-------- Mensaje original --------
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows
Server 2012
*De: *fabianoas...@gmail.com [firebird-support]
<firebird-support@yahoogroups.com>
*Para: *firebird-support@yahoogroups.com
*Fecha: *30/12/2015 11:57
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 guse...@gmail.com
<mailto:guse...@gmail.com> [firebird-support]"
<firebird-support@yahoogroups.com
<mailto: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 aharri...@ibphoenix.com
<mailto:aharri...@ibphoenix.com> [firebird-support]
<firebird-support@yahoogroups.com>
<mailto:firebird-support@yahoogroups.com>
*Para: *firebird-support@yahoogroups.com
<mailto:firebird-support@yahoogroups.com>
<firebird-support@yahoogroups.com>
<mailto:firebird-support@yahoogroups.com>
*Fecha: *29/12/2015 17:26
On Tue, Dec 29, 2015 at 2:44 PM, Macma mac...@wp.pl
<mailto:mac...@wp.pl> [firebird-support]
<firebird-support@yahoogroups.com
<mailto: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
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
Este correo electrónico se ha enviado desde un equipo libre de
virus y protegido por Avast.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
---
El software de antivirus Avast ha analizado este correo electrónico en busca de
virus.
https://www.avast.com/antivirus
