Subject Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Author Carlos H. Cantu
Post date 2014-02-16T23:59:53Z
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 FB 2.5.2 is supposed to have "workarounded" this problem.

Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br




Hello all again,

I have met more computers with Windows 2008 R2 64bit where the performance is very bad.

I was importing into database about 80 GB files into tables with blob fields I had to use for server
casual Windows 7 32bit computer to get it done on time.

How can it be, that Intel i3 with 4GB RAM 32bit is 6 times faster that multi CPU Xeon server.
Every core was 100% busy when executing SQL statements.

...

I don't believe that I am the only one having these problems.


<SL> This is a known problem with 64 bit versions of all Windows products.
<SL> The problem is that 64bit build want to use up to 1TB of RAM (ie. all available) for file cache purposes.
<SL> You need to look the Dynamic Windows Cache service from Microsoft.


Sean