We found a possible solution for the problem. We changed Firebird to
work in async mode. Now it is very rapid (again). Does anyone know
the impact of this change? We have read about this setting to be
unreliable on Windows system.

On Fri, Dec 3, 2010 at 4:02 PM, Vander Clock Stephane
<svanderclock@...> wrote:

> I aslo run FB 2.5 on DELL poweredge with RAID 0 on wndows 2008 R2
> and we don't have such problem
>
> On 12/2/2010 8:25 PM, Maarten Klerk wrote:
>> Hi all,
>>
>> Does anyone have a suggestion to solve the following problem?
>>
>> We are running Windows Server 2008 R2 on a brand new Dell PowerEdge
>> with 4 cores and a RAID contoller system, with 2 harddisks.
>>
>> On top of it we run an application server and a firebird server (2.1,
>> superserver).
>>
>> In this configuration Firebird seems to be very slow. It really slows
>> down our whole application. It seems to be caused by the combination
>> of firebird and a RAID controller. (I googled it). I would like to
>> prove that this is the problem in our case as well.
>>
>> We did the following test in order to narrow down the problem. It was
>> done by means of IBExpert and SQL Server Management console.
>>
>> In IBExpert we created the following tables:
>> TESTTBL and CLONE, created a before insert trigger on testtbl
>> Filled CLONE with 15000 records
>> Run ‘insert into testtbl select * from clone;’
>>
>> We ‘ve got the following results:
>>
>> Firebird:
>>
>> Laptop 1: 3 seconds
>> Laptop 2: 1,7 second
>> Server: 5 seconds
>>
>>   We did the same test on SQL Server Express (just to have a comparison).
>>
>>
>> SQLServer Express:
>> Laptop 1: 520 ms
>> Laptop 2: 400 ms
>> Server: : 400 ms
>>
>> Can anyone from the firebird community help me to explain the
>> differences and explain what might be wrong in the configuration?
>>
>> How is the firebird driver behaving with respect to keeping files open?
>>
>>
>> Thanks in advance!
>>
>> Maarten Klerk
>>
>>
>> ------------------------------------
>>
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>> Visit http://www.firebirdsql.org and click the Resources item
>> on the main (top) menu.  Try Knowledgebase and FAQ links !
>>
>> Also search the knowledgebases at http://www.ibphoenix.com
>>
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>> Yahoo! Groups Links
>>
>>
>>
>>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu.  Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>