Subject Re: [firebird-support] Firebird 2.1.x performance magic
Author Macma
W dniu 2010-07-14 12:01, Macma pisze:
> Hi,
> I have faced very strange situation with Firebird 2.1.3 performance.
> I'm using FireBird 2.1.3 (x64) with default configuration on Windows
> 2008 R2 Foundation PL (x64).
> My 32 bit application connecting to firebird via TCP connection
> (localhost) using 32-bit fbclient.dll (C++Builder 2007 with UIB
> components).
> It store about 700 record on every 30 seconds in some database. Which
> consume about 5-8 seconds witch is very long considerate FB 1.5 on
> windows server 2003 R2 and similar hardware where it's took below 1s.
> >From time to time every thing speeds up to "normal" where average write
> time were +/- 0,3s.
> I try to investigate this performance issue because I use (x64)
> architecture for the first time.
> I have found things witch I can't explain reasonable.
> When I run only my application I had performance issue, it takes about
> 5-8s to write 700 records and the average disk queue length come up to
> 100 for that time. So i think this could be some storage issue.
> But here comes the funny part, I only run Database Workbench 4 (I don't
> made any connection from it only accept trial dialog) and every thing
> speed up to normal, where write time was less than 0,5 s and average
> disk queue length come below 50.
> I also found that the same performance boost I get when I run firefox
> with any flash application (at lest some flash banners on site) :).
> Is there anyone who have similar performance issue or have Idea what
> connecting this things.
> I still don't believe what I see. I have check on two hardware
> configuration and it's reproducible every time.
> Any help appreciated.
> Regards,
> Macma

I finally found the reason of this poor performance. It's driver for HP
SmartArry P400 witch are broken above Version: (B) (6 May 2009).
I was using version (8 Mar 2010) so now when I downgrade to (B) everything works fine for me.

But I still can't explain why DB workbench and flash apps boost this