Subject RE: [firebird-support] Bad surprise on performance
Author Leyne, Sean
> 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