Thursday, 24 December 2015

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

 

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@warmboot.com.br [firebird-support] <firebird-support@yahoogroups.com>
Para: Eduardo gusedum@gmail.com [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



__._,_.___
Posted by: "Carlos H. Cantu" <listas@warmboot.com.br>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (4)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

.

__,_._,___
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)