Fascinating...
I created a test table on both old and new server to play with updates
and inserts (~ 150.000 records)
Performance with 2.5.3 x64 on Win2008 is constantly
changing, but at best its some 8 seconds and worst even 2 minutes!
Performance with 1.5.4 x86 on Win2003 is always about the same, and
always 2.9 - 3.2 seconds.

My next steps will be:
- get some sleep
- reduce example to a database with only this one testtable
- install 2.5.3 on 2 other new servers (different RAIDs) and test
there
- test also with 2.5.3 CS x86, 2.5.3 SS x64/x86, 1.5.4 CS x86
- fire myself before presenting bill for new server to my boss unless
I find a solution

If somebody *KNOWS* for sure that Firebird just won't work on
Server2008, or if someone knows for sure that it does, please drop a
note.


Query
------------------------------------------------
update X3058000 x
set
x.p3058_004n = (x.p3058_004n * 2)

Plan
------------------------------------------------
PLAN (X NATURAL)


Query Time (new Server))
------------------------------------------------
Prepare : 0,00 ms
Execute : 30.781,00 ms
Avg fetch time: 0,00 ms

Query Time (old Server)
------------------------------------------------
Prepare : 15,00 ms
Execute : 3.110,00 ms
Avg fetch time: 0,00 ms


Memory (new Server)
------------------------------------------------
Current: 10.412.912
Max : 10.504.672
Buffers: 2.048

Memory (old Server)
------------------------------------------------
Current: 5.887.792
Max : 6.158.624
Buffers: 2.048


Operations (new Server)
------------------------------------------------
Read : 2.247
Writes : 5.960
Fetches: 2.476.240
Marks : 807.922

Operations (old Server)
------------------------------------------------
Read : 8.516
Writes : 6.084
Fetches: 1.602.243
Marks : 582.584




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


=====================================================================
Ihre Nachricht:

> 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
> migrate.

> 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.

> [Old]
> 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
> up...)

> [new]
> 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



> ------------------------------------

> ------------------------------------

> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu. Try FAQ and other links from the left-side menu there.

> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/

> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ------------------------------------

> Yahoo Groups Links