Odp: [firebird-support] firebird performance on xeon cpu

2013-08-27 Thread liviusliv...@poczta.onet.pl
Hi, This is cache problem of win64 not firebird itself. i do not remember link but try with google firebird eat whole memory or somethink like this. Regards, Karol Bieniaszewski - Reply message - Od: "Alexis Diel" Do: Temat: [firebird-support] firebird performance on xeon cpu Data: śr

Re: [firebird-support] firebird performance on xeon cpu

2013-08-27 Thread Alexis Diel
I'm actually having this same problem with one of my clients. He have two servers with x64 Windows and 8Gb of RAM. One of them is xp, the other is seven. I tested Firebird 2.5.2 x32 and x64... change various configuration and no success yet to reduce the consume of memory... that after a while get

Re: [firebird-support] firebird performance on xeon cpu

2013-08-27 Thread 安占江
于 2013年08月27日 23:53, Leyne, Sean 写道: > > > > > I have resolved this question. > > on disk driver property labels, I checked the close window cache on > disk, > > which is unchecked by default. > > but I don't known the reason. > > Actually, changing that setting is VERY DANGEROUS, it could lead to

Re: [firebird-support] Why does a query take many times as long the first time it's run?

2013-08-27 Thread Ann Harrison
On Tue, Aug 27, 2013 at 12:32 PM, Leyne, Sean wrote: > Ann, > > > Without the query (and any procedures it invokes) I can't say for > certain that > > you're seeing garbage collection. It does seem odd that the second run > also > > involves writes. > > If an older transaction was committed betwe

Re: [firebird-support] help with gsec

2013-08-27 Thread Alexandre Benson Smith
Hi ! Em 27/8/2013 10:27, Holcomb, Satin escreveu: > I work for a very large organization but have never used Firebird before. We > have an office in Portugal that uses it with T&T Accounting Software. The > user that used the program is no longer there and no other users are able to > use it

[firebird-support] help with gsec

2013-08-27 Thread Holcomb, Satin
I work for a very large organization but have never used Firebird before. We have an office in Portugal that uses it with T&T Accounting Software. The user that used the program is no longer there and no other users are able to use it. The users cannot provide assistance because they speak ver

RE: [firebird-support] Why does a query take many times as long the first time it's run?

2013-08-27 Thread Leyne, Sean
Ann, > Without the query (and any procedures it invokes) I can't say for certain that > you're seeing garbage collection. It does seem odd that the second run also > involves writes. If an older transaction was committed between the execution of the 2 queries, would garbage collection not clean

Re: [firebird-support] Why does a query take many times as long the first time it's run?

2013-08-27 Thread Ann Harrison
On Tue, Aug 27, 2013 at 10:29 AM, Tim Ward wrote: > The first time I run a certain SELECT query after not running it for a > while (hours or days) I might get stats like: ( > (stats below) > > (note 2 seconds instead of 167 seconds) . Subsequent runs then take > consistently 2 seconds. > > Wha

[firebird-support] Re: Firebird 2.5.x on Windows Server 2012

2013-08-27 Thread kittikira
Thank you Sean. That helps. Helmut --- In firebird-support@yahoogroups.com, "Leyne, Sean" wrote: > > > > > I have a request from a customer that wants to setup a Windows 2012 Server > > and now I want to ask if there are any known issues about firebird 2.5.x on > > a > > Windows Server 2012.

RE: [firebird-support] firebird performance on xeon cpu

2013-08-27 Thread Leyne, Sean
> I have resolved this question. > on disk driver property labels, I checked the close window cache on disk, > which is unchecked by default. > but I don't known the reason. Actually, changing that setting is VERY DANGEROUS, it could lead to database corruption! The setting tells the OS to ass

RE: [firebird-support] Firebird 2.5.x on Windows Server 2012

2013-08-27 Thread Leyne, Sean
> I have a request from a customer that wants to setup a Windows 2012 Server > and now I want to ask if there are any known issues about firebird 2.5.x on a > Windows Server 2012. > > Is it working well or are there any problems I will expect. We have deployed it on several Win2012 servers, no

Re: [firebird-support] Why does a query take many times as long the first time it's run?

2013-08-27 Thread Norman Dunbar
Hi Tim, On 27/08/13 15:29, Tim Ward wrote: > The first time I run a certain SELECT query after not running it for a > while (hours or days) I might get stats like: > > Current memory = 3265728 > Delta memory = 290716 > Max memory = 3267368 > Elapsed time= 166.92 sec > Buffers = 150 > Reads = 92650

[firebird-support] Why does a query take many times as long the first time it's run?

2013-08-27 Thread Tim Ward
The first time I run a certain SELECT query after not running it for a while (hours or days) I might get stats like: Current memory = 3265728 Delta memory = 290716 Max memory = 3267368 Elapsed time= 166.92 sec Buffers = 150 Reads = 92650 Writes 65659 Fetches = 16182424 If I immediately run the s

[firebird-support] Rdb$admin role in services API

2013-08-27 Thread remk_1
Hi, The new rdb$admin role in FB 2.5 allows (when granted) a regular user to backup database by gbak (using the "-role rdb$admin" command-line parameter). From gbak, it is also possible to do the same through services API (by adding "-service" command-line parameter). But I can't find a way ho

[firebird-support] Firebird 2.5.x on Windows Server 2012

2013-08-27 Thread kittikira
Hello, I have a request from a customer that wants to setup a Windows 2012 Server and now I want to ask if there are any known issues about firebird 2.5.x on a Windows Server 2012. Is it working well or are there any problems I will expect. Kind regards Helmut