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] <firebird-support@yahoogroups.com> escribió:
>
>
>
> I discovered something else qui
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.
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
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>:
>
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"
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
I forgot to mention that I'm monitoring the linux server where
Firebird is installed and this is what I see:
- no high CPU load
- no swapping
- no io waiting
What seems very strange to me is that firebird process is taking very
few CPU (0.7%)...I think it should be much higer as I'm asking for a
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
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
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'
I would like to know if someone has accomplished a migration from
Interbase 7.5 to Firebird 2.5.4 or if there some documentation or
guidelines I could follow.
Thanks in advance.
--
--
Planatec Software S.L. ** http://www.planatec.es
telf: +34 964 340 560 ** fax: +34 961 130 921
Is there any rpm for x86_64 arquitectures on linux? At the downloads
page I could only found packages for x86 or AMD64.
Thanks in advance!!
--
--
Planatec Software S.L. ** http://www.planatec.es
telf: +34 964 340 560 ** fax: +34 961 130 921
12 matches
Mail list logo