Subject Re: Firebird 1.03 slow connection with Win2003 server
Author remk_1
--- In firebird-support@yahoogroups.com, "clementdoss" <cdoss@d...>
wrote:
> Hello,
>
> After upgrade from Win2k Server to Win2003 server, the applications
> are taking longer to connect (+/- 10sec).
> Is this a known issue?
> Is there any setting on Windows server to solve this?
> Is there any settings on firebird side (hope so)?
> When will FB 1.5 be released for production environment?
>
> Best regards,
> Clement

Hi Clement,

Some time ago I came across a similar problem. After some
experimenting I found that it helps to switch "Application response"
from "Background services" to "Applications" (Control Panel ->
System -> Advanced -> Performance Options). This influences the
registry key Win32PrioritySeparation
(HKLM\SYSTEM\CurrentControlSet\Control\PriorityControl) whose middle
two bits seem to make the difference. They control the kind of OS
timeslices - fixed vs variable. Well, it is strange to optimize
database server's OS for applications, but it helped.

I also found that the connect/disconnect time is OK in FB 1.5, but I
noticed other casual delays during heavy insert operations when the
switch was left in "Background services". I think all this is related
to a bug that is mentioned in FB WhatsNew.Txt (Long delays during
connecting/disconnecting on WinXP) and was repaired in FB 1.5.
Although, as I wrote, there are still situations where the switch may
help.

Regards,
Michal