Subject | RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 |
---|---|
Author | Leyne, Sean |
Post date | 2014-01-20T23:44:21Z |
> I found some info about problems with performance when FB is running onWhat is the database file size?
> 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.
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