|Subject||RE: [firebird-support] Bad surprise on performance|
> 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.
> 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
> 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.