OK, thank you. I understand.
I tried deinstalling 2.1.4 and installing 2.1.7. But the performance was
the same. Nothing improved! :-(
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?
Regards
Eduardo
-------- Mensaje original --------
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows
Server 2012
*De: *'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
<firebird-support@yahoogroups.com>
*Para: *Eduardo guse...@gmail.com [firebird-support]
<firebird-support@yahoogroups.com>
*Fecha: *24/12/2015 14:50
One cache problem is the one mentioned in the article, fixed in 2.1.5,
etc.
The other is the fact that PDC machine will always have write cache
disabled.
Carlos
www.firebirdnews.org <http://www.firebirdnews.org>-
www.FireBase.com.br <http://www.FireBase.com.br>
Carlos:
Thank you for your answer.
I suggested to not configure the server as a domain controller but the
person who decide this didn´t want!
I already read the article you mention and there is where I found that
apparently upgrading to 2.1.5 will solve the problem but I was not
sure. So if I upgrade, the performance would be similar as if disk
cache was enabled?
I don´t understand what do you mean saying "The cache problem you are
referring to is another thing". Are there TWO cache problems? Which is
THE OTHER? Please, can you explain me?
Regards
Eduardo
-------- Mensaje original --------
*Asunto: *Re: [firebird-support] Bad performance of Firebird in
Windows Server 2012
*De: *'Carlos H. Cantu' lis...@warmboot.com.br
<mailto:lis...@warmboot.com.br>[firebird-support]
<firebird-support@yahoogroups.com>
<mailto:firebird-support@yahoogroups.com>
*Para: *Eduardo guse...@gmail.com
<mailto:guse...@gmail.com>[firebird-support]
<firebird-support@yahoogroups.com>
<mailto:firebird-support@yahoogroups.com>
*Fecha: *24/12/2015 12:47
Never use Firebird (or any RDBMS) in a PDC machine! Windows will
always disable write disk cache in PDC, and it will be very bad for
any write sensitive application, like databases (not only Firebird).
The cache problem you are referring to is another thing, and to solve
this one, you need to upgrade to 2.1.5 (at last):
http://dyemanov.blogspot.com.br/2012/03/firebird-vs-windows-file-system-caching.html
Carlos
www.firebirdnews.org <http://www.firebirdnews.org>-
www.FireBase.com.br <http://www.FireBase.com.br>
Hi guys:
I have an application developped in Delphi that uses Firebird
Superserver 2.1.4.18393.
It is installed in a Windows network. During many years, the server
had Windows Server 2003 and everything worked fine. Some time ago they
changed it temporarily to another PC with Windows 8.1. Everything
worked fine.
A few days ago they installed a new server with Windows Server 2012.
My application is working, but it works very slow. It has a log file
and I verified that the bad performance occurs in every data base
access, when it opens a database, when it executes any SQL, etc.
I did a little research and found that, apparently, the problem is
related with the disk cache. In the old servers, disk cache was
enabled but in the new one with Windows Server 2012 it is disabled
and, as the server is configured as a domain controller, as far as I
know, it can´t be enabled.
I read some articles about problems similar to this one and apparently
this is a problem related with Firebird. In some articles they said
that since version 2.1.5 this is solved. ¿Is this true?
¿Updating to 2.1.5 will solve the problem?
¿Is there something I can do to solve this without updating?
Any suggestions will be welcome!
Regards
Eduardo
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>
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
