search

FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.26k stars 216 forks source link

Slow performance in firebird installed on windows server 2008 promoted to domain controller. [CORE3890] #1436

Open firebird-automations opened 12 years ago

firebird-automations commented 12 years ago

Submitted by: Ágile Sistemas Ltda (agilesistemas)

I'm having serious performance loss problems using firebird installed in a Windows Server 2008 promoted to domain controller. When I install firebird in windows 7 or windows server 2008 without being the domain controller, queries run very fast, as should be. But if I promote windows server 2008 to domain controller, read and write operations becomes 10-50 times slower. I made a test application that create a table and make 5000 inserts, a select of all this records, followed several updates and deletes. It normally takes 30 to 40 seconds to do everything in windows 7 or windows server 2008 without domain controller. After the domain promotion, the time go for almost 6 minutes! Curiously, if I demote the domain it continues to be slow. I need to format the computer and install Windows again, then it becomes fast again. I use delphi, and made several tests, using IB components and dbExpress drivers, to see if were anything related to the drivers, but the result is the same. I also made the same test with postgresql, and it worked fine, with no problems, with or without the domain. But I use firebird in all of my applications, and I don't want to migrate to postgresql right now. I'm looking for help, if you have a little time to look into it, I can send my test application, and you can see the problem. I also can send my application results, if needed. Thanks Tiago.

firebird-automations commented 12 years ago

Commented by: @dyemanov

Please don't post support questions to the bug tracker, use the appropriate mailing list instead.

firebird-automations commented 12 years ago
Modified by: @dyemanov security: Developers \[ 10012 \] =\>
firebird-automations commented 12 years ago

Commented by: Ágile Sistemas Ltda (agilesistemas)

Hi Dmitry, Thank you for answer it shortly. I really though it was a problem with firebird, because I already tried every configuration that I found that could be related to it, and anything worked. I have several customers of our applications, and when they migrato to Windows server 2008 promoted to domain, this problem occurs. I tried to find it on the support mainling list, and some people related it there too, but any answer seems to solve the problem. If you can help me, please, tell me where I can find a configuration that can solve it. It is not related to RAID controllers, because I tested in other 2 machines, that use SATA HDs and the same performance loss occurs when I promote Windows to domaind controller. Thanks Tiago

firebird-automations commented 12 years ago

Commented by: @dyemanov

The write-through cache setting is disabled at the Windows level, not at the RAID level, so it doesn't make any difference.

firebird-automations commented 12 years ago

Commented by: Ágile Sistemas Ltda (agilesistemas)

Thank you Dmitry, I managet to enable the write-through cache in Windows, in my test computer, and it really worked fine, the time for read and write became normal again, but I have a Dell machine as server, that does not allow to enable the write-through cache in Windows. It gives me a message that the device does not suport it. Well, them I tryied to change the settings on Firebird, and I changed the FileSystemCacheThreshold to 0, and it didn't work as well. After I also changed FileSystemCacheSize to 0 and notting happens again. In Dell machine, that I cannot enable the write-through cache in Windows, Firebird is still having performance problems. Thanks Tiago