Subject Bad surprise on performance
Author André Knappstein
Hey! Happy new year to all!

For me, it should have started with something great, new...
FINALLY! The migration from FB 1.5 to 2.5 (trust me, I had reasons not
to do it earlier). But now the old appications are all gone, and I can

Seems there will be a delay. I migrated the database from old hardware
running 1.5.4 to new hardware running 2.5.3. Backup/Restore is about 4
times faster. Wow!
But normal working is - at least - 50% slower sometimes worse.

I already scanned the newsgroups and noticed that other users had the
same problem, but none of them seems to have found a good solution.
For me - being only a part time wannabe administrator - I really don't
have a clue where to start looking.

Here are some details of the 2 systems; if anybody can point me into a
direction where to look first it would be most welcome.

Server 2003 x86 no service packs
Xeon with 4 GB RAM
Classic 1.5.4 (x86, of course)
Raid 0 on 2 * 500 GB SAS (though this is from memory, I should look it

Server 2008 R2 x64 SP1
Xeon with 8 GB RAM (I will shortly add +8)
Classic 2.5.3 x64
Raid 0 on 3 * 600 GB SAS

In comparison to what I read from others, my databases are small.
Biggest database is some 1 GB only.
Bad performance on updates and inserts and extremely bad performance
on committing a big number of record changes (~ 150.000 updates).

Database has 4096 Page Size and 2048 buffers (which sounds like
setting for SS but I specifically set it higher to use more RAM
according to a hint from experts).

While testing the configuration, nobody is in the network.
Firebird runs on dedicated server (just windows and Firebird).

where to look?

mit freundlichen Grüßen,

ppa. André Knappstein
EDV und Controlling
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe

Telefon: +49 2389 9240 140
Telefax: +49 2389 9240 150
e-mail: knappstein@...

Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus

USt-IDNr.: DE 125215402