|Subject||RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2|
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.