Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
firebird-automations opened this issue Jul 13, 2012 · 5 comments
Open

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

firebird-automations opened this issue Jul 13, 2012 · 5 comments
Labels
affect-version: 2.1.5 affect-version: 2.5.1 affect-version: 2.5.2 priority: major type: bug

Comments

@firebird-automations
Copy link
Collaborator

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
Copy link
Collaborator Author

Commented by: @dyemanov

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

security: Developers [ 10012 ] =>

@firebird-automations
Copy link
Collaborator Author

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
Copy link
Collaborator Author

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
Copy link
Collaborator Author

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affect-version: 2.1.5 affect-version: 2.5.1 affect-version: 2.5.2 priority: major type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@firebird-automations