Subject Re: [firebird-support] Re: Huge speed problem after changing CPU do Dual Core (FB1.5.3)
Author Luis Madaleno
Hi,

CPUAffinity defaults to 1. So this shouldn't be a problem.
But I also changed this value to 2 with no change.

I also guess this might be a network problem, but this was working very well before the HW upgrade.
In my connection string I use the server's IP address and not the server's name.

Regards,

Luis



Adam wrote:
> --- In firebird-support@yahoogroups.com, Luis Madaleno <luis@...> wrote:
>
>> Hi,
>>
>> I have this machine running Windows 2003 Server with FB1.5.3 SS.
>> It had an AMD Opteron CPU with an ASUS SK8N, but I had to change the
>>
> CPU
>
>> and mainboard to an AMD 64 X2 with an ASUS A8NE.
>> The network card also changed, but the rest is the same, including the
>> OS instalation that restarted well with the new HW.
>>
>> But now all FB client apps take almost one minute to connect to the FB
>> Server. It seems they keep searching for the server.
>> After they load user complaint that the app is very very slow
>>
> connecting
>
>> the first time to any table.
>> Running the app at the server loads fast but takes a while
>>
> connecting to
>
>> any table for the first time.
>>
>> A tried to reinstall FB in many ways: 1.5.3 SS again, 1.5.2 SS again,
>> 1.5.3 CS, and nothing changed.
>>
>> Need help real real soon please.
>>
>
> Is it bouncing between the CPUs? If so, you can set the CPUAffinity
> mask to lock it to a single processor in Firebird.conf (restart the
> service after changing).
>
> Slow to connect specifically isnt normally related to this. It is more
> frequently
>
> 1) .gdb files on XP
> 2) Disk Shadowing on 2003.
>
> I also wouldn't rule out in this case some network issue where it
> takes a long time to resolve the hostname. It could be attempting to
> resolve an address from a DNS server and timing out, particularly if
> the delay is an identical time every time. Add an entry to the hosts
> file to prevent this lookup.
>
> Adam
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>


[Non-text portions of this message have been removed]