Re: [firebird-support] About firebird performance

Hi Jesus...I'm using SuperServer version for testing purposes as I think is the most closed to IB75 behaviour. 2015-09-05 18:50 GMT+02:00 Jesus Garcia jeg...@gmail.com [firebird-support] : > > > Hello Hector, what version of firebird are you running, super

Re: [firebird-support] About firebird performance

Thanks for your reply Ann...please see below your comments: > Very odd. Could you collect the performance stats for the query on the two > systems? >Specifically, I'd like to know how much physical I/O each did - > that's reported as Reads >and Writes. Fetches and Marks don't matter here.

Re: [firebird-support] About firebird performance

Thanks Alexey!! As you have read, setting pagebuffers to 0 on the database solved the problem and now it works as I expected. 2015-09-05 19:06 GMT+02:00 Alexey Kovyazin a...@ib-aid.com [firebird-support] : > > > Hi Hector, > > > I discovered something else

Re: ODP: Re: [firebird-support] About firebird performance

always disable system cache Regards, Karol Bieniaszewski Oryginalna wiadomość Od: "Alexey Kovyazin a...@ib-aid.com [firebird-support]" <firebird-support@yahoogroups.com> Data: 05.09.2015 19:06 (GMT+01:00) Do: firebird-support@yahoogroups.com Temat: Re: [firebir

Re: [firebird-support] About firebird performance

2015.09.05. 9:00 keltezéssel, Hector Sánchez hec...@planatec.es [firebird-support] írta: > - I have a linux server with firebird 2.5.4 Superserver: multi-core (4), 3GB > RAM Hi, Can you test with 3.0 (Beta 2 or snapshot)? Gabor

Re: [firebird-support] About firebird performance

Thanks Vlad...you found the problem!! I set FileSystemCacheThreshold to 50 and it works like a charm...I got chache for the db and works really fast...even in the VM. Thanks!! 2015-09-05 23:36 GMT+02:00 hv...@users.sourceforge.net [firebird-support] < firebird-support@yahoogroups.com>: >

ODP: Re: [firebird-support] About firebird performance

: "Alexey Kovyazin a...@ib-aid.com [firebird-support]" <firebird-support@yahoogroups.com> Data: 05.09.2015 19:06 (GMT+01:00) Do: firebird-support@yahoogroups.com Temat: Re: [firebird-support] About firebird performance  

[firebird-support] About firebird performance

I'm doing some basic tests with Firebird and I'm facing something I cannot understand (I'm a newbie to Firebird which has worked with IB7.5 for years, so I apologize if I ask something obvious): - I have a linux server with firebird 2.5.4 Superserver: multi-core (4), 3GB RAM - I placed a "huge"

Re: [firebird-support] About firebird performance

He again Alexey, As I suspected, my problem is not caused by GC: gstat over the table reported this: TABLE1 (503) Primary pointer page: 9374, Index root page: 9375 Average record length: 317.63, total records: 3261775 Average version length: 0.00, total versions: 0, max versions: 0

Re: [firebird-support] About firebird performance

Hi Hector, I discovered something else quite interesting: I realized both IB and FB dbs have pagebuffers set to 100.000. I changed FB to 0 and now it works like I expected!!..Same query now completes on FB on 50 sec. It seems this is the problem although I don't understand why. 100 000 is

Re: [firebird-support] About firebird performance

On Sat, Sep 5, 2015 at 12:00 PM, Hector Sánchez hec...@planatec.es [firebird-support] wrote: > > > I discovered something else quite interesting: > > I realized both IB and FB dbs have pagebuffers set to 100.000. I changed > FB to 0 and now it works like I

RE: [firebird-support] About firebird performance

> Hi Hector, > > > I discovered something else quite interesting: > > > > I realized both IB and FB dbs have pagebuffers set to 100.000. I changed FB > to 0 and now it works like I expected!!.. > > Same query now completes on FB on 50 sec. It seems this is the problem > although I don't

Re: [firebird-support] About firebird performance

> ---In firebird-support@yahoogroups.com, wrote : > > I discovered something else quite interesting: > > I realized both IB and FB dbs have pagebuffers set to 100.000. I changed FB > to 0 and now it works like I > expected!!..Same query now completes on FB on 50 sec. It seems

Re: [firebird-support] About firebird performance

Re: [firebird-support] About firebird performance

I discovered something else quite interesting: I realized both IB and FB dbs have pagebuffers set to 100.000. I changed FB to 0 and now it works like I expected!!..Same query now completes on FB on 50 sec. It seems this is the problem although I don't understand why. Nevertheless, I'll try on a

Re: [firebird-support] About firebird performance

Not exactly the same machine, but almost...same server config, same linux distro. In order to make tests with FB try to be comparable I tried to have exact the same machines. I'll do what you suggest and post results. There must be something stupid but I cannot see it as it's not possible

Re: [firebird-support] About firebird performance

Re: [firebird-support] About firebird performance

Thanks Carlos...environments are exactly the samethat's why semmed strange to me. It might be caused by the way FB and IB access disk that it's different in some way and makes my VMs get saturated. I'll try on a physical server and let you know. 2015-09-05 15:52 GMT+02:00 'Carlos H. Cantu'

Re: [firebird-support] About firebird performance

Hello Hector, what version of firebird are you running, super server, super classic or classic server? Jesus Angel Garcia Zarco Cointec > El 5/9/2015, a las 18:00, Hector Sánchez hec...@planatec.es > [firebird-support] escribió: > > I discovered something