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.

Regards
Macma

-------- 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 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 - 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' 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

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