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

Hi Karol, I know it from our experience. The explanation that big page cache requires extra resources for synchronization, and experiments shows that combination of 10k buffers and enabled file cache gives the best performance for SuperServer 2.5. However, in 3.0 situation is improved, and

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

Hi, For superserver this should be as high as possible.  Why you recommended 1 value? I always set it to highest possible value in current environment compared to size of database. And i always disable system cache Regards,Karol Bieniaszewski Oryginalna wiadomość Od: