Subject Re: [firebird-support] Firbird slow performance at windows server 2012
Author Wewe
Before use windows server 2012 (i7, 8GB ram) i used windows xp profesional (dual core, 2GB ram). There is no problem with the application or queries.
I just copy the database into windows server 2012, the number of  users is same, queries is same to. everything is identical

I use FB 2.1 64 bit and try  2.5 64 bit



From: Alexandre Benson Smith <iblist@...>
Sent: Tuesday, July 9, 2013 12:24 AM
Subject: Re: [firebird-support] Firbird slow performance at windows server 2012

Em 8/7/2013 05:51, Svein Erling Tysvær escreveu:
>> Dear All,
>> I have application with delphi and firebird database, there is no problems until migrate the server to windows server 2012.
>> The query (select, insert, update etc) running to slow.
>> I searching and found the solution example : change filesystemcache,tempbocksize,defaultdbcachepages at firebird.conf but
>> the query still running to slow.
>> There are another way?
> Please tell us more, Chandra, even though I know nothing about Windows vs Firebird, I know that a detailed and specific problem description is more likely to result in good answers than general questions. You say that you migrate to Windows server 2012, what do you migrate from? Is everything except the server identical on the fast and slow server - e.g. indexes and plans for all problematic queries? The same number of users and the same content in the databases? What about database statistics? If there are specific queries running slow, you could post them here together with the generated plans and some information about the fields in the indexes being used.
> Set

Besides that.

Wich FB version ?

Newer windows versions (64bit) has changed th way to manage filesystem
cache and it became a problem...

Read more here:

see you !

[Non-text portions of this message have been removed]