Subject Re: [firebird-support] Firbird slow performance at windows server 2012
Author Alexandre Benson Smith
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 !