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 Thanks Chandra ________________________________ From: Alexandre Benson Smith <[email protected]> To: [email protected] 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: http://dyemanov.blogspot.com.br/2012/03/firebird-vs-windows-file-system-caching.html see you ! [Non-text portions of this message have been removed]
