Re: [firebird-support] Firbird slow performance at windows server 2012
On Mon, 8 Jul 2013 20:07:02 -0700 (PDT), Wewe sullen...@yahoo.com wrote: 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 Instead of copying, what happens if you use a backup/restore? Mark
[firebird-support] Firbird slow performance at windows server 2012
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 help me Thanks Chandra [Non-text portions of this message have been removed]
RE: [firebird-support] Firbird slow performance at windows server 2012
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
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 !
Re: [firebird-support] Firbird slow performance at windows server 2012
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 ibl...@thorsoftware.com.br To: firebird-support@yahoogroups.com 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]
