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 !
