Subject Re: [firebird-support] Bad surprise on performance
Author André Knappstein
Thank you for the prompt answer, Sean.
But, no, I have read about this specific one.
And though I am sure I did not fully understand about it yet, since my
biggest database is only 1 GByte I *thought* this would not be a
problem for me.


=====================================================================
Ihre Nachricht:


>> Seems there will be a delay. I migrated the database from old hardware
>> running 1.5.4 to new hardware running 2.5.3. Backup/Restore is about 4
>> times faster. Wow!
>> But normal working is - at least - 50% slower sometimes worse.

>> [Old]
>> Server 2003 x86 no service packs
>> Xeon with 4 GB RAM
>> Classic 1.5.4 (x86, of course)
>> Raid 0 on 2 * 500 GB SAS (though this is from memory, I should look it
>> up...)
>>
>> [new]
>> Server 2008 R2 x64 SP1
>> Xeon with 8 GB RAM (I will shortly add +8) Classic 2.5.3 x64 Raid 0 on 3 * 600
>> GB SAS

> Let me guess, you database is larger than 8GB (or 16GB in size)?

> The problem is not with Firebird...

> Your problem is the infamous Windows 64bit File Cache causes excessive Page File usage.

> There are a large number of posts on this subject in this forum but also on the web.


> Sean



> ------------------------------------
> Posted by: "Leyne, Sean" <Sean@...>
> ------------------------------------

> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu. Try FAQ and other links from the left-side menu there.

> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/

> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ------------------------------------

> Yahoo Groups Links