Subject | RE: [firebird-support] Bad surprise on performance |
---|---|
Author | Leyne, Sean |
Post date | 2015-01-02T23:14:36Z |
> Seems there will be a delay. I migrated the database from old hardwareLet me guess, you database is larger than 8GB (or 16GB in size)?
> 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
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