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