Subject RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Author Leyne, Sean
> I found some info about problems with performance when FB is running on
> Win2008R2 which is domain controller.
> But in my case is it not DC, but the performance is the worst I met.
> It is new server running 10GB of RAM, RAID, ... it is quite new
> server box.
>
> It cannot be, that basically dummy update on table with about 700 000
> records is executing over one hour. CPU is relaxing, HDD is relaxing too and I
> cannot force server to fun faster.

What is the database file size?

Is the DB file larger than RAM?

If so, there are known issues with Window file cache performance under x64 mode. Check list archives for previous posts or google "Windows 64 file cache performance".


Sean