Subject | Re: [firebird-support] Bad performance of Firebird in Windows Server 2012 |
---|---|
Author | Eduardo |
Post date | 2015-12-24T16:21:51Z |
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
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' listas@... [firebird-support] <firebird-support@yahoogroups.com>
Para: Eduardo gusedum@... [firebird-support] <firebird-support@yahoogroups.com>
Fecha: 24/12/2015 12:47
Asunto: Re: [firebird-support] Bad performance of Firebird in Windows Server 2012
De: 'Carlos H. Cantu' listas@... [firebird-support] <firebird-support@yahoogroups.com>
Para: Eduardo gusedum@... [firebird-support] <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 - 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
Este correo electrónico se ha enviado desde un equipo libre de virus y protegido por Avast.
www.avast.com