I have seen similar effects at some customer sites.
I run a large sql script (selects/updates/deletes, create tables, alter
tables), first it runs fine and than processor usage drops down to 1%.
This could take hours (for a script that normally takes only a few
minutes) before it runs at normal speed again.
I think most of the machines are using Win 2003 or Win 2000 Server and
are Multiprocessor or have HT.
But i can remeber one customer that only have a single Xeon Processor
(without HT) (and Win2003 Small Business Edition).
But i don't know a solution. Fortunately i don't have to run this kind
of scripts very often.

mfg
Carsten

Chau Chee Yang schrieb:

>
> Hi,
>
> I have a machine:
>
> - Intel Core 2 2.4G
> - 1G RAM
> - Windows 2003 standard version
> - Firebird 1.5.3
>
> When I run my program to access the Firebird database, I have
> performance problem. The response is very slow compare to Windows XP
> machine. I have done the following tuning to the Firebird server and
> it doesn't help:
>
> 1. Install Firebird 1.5.3 Super server and change CPUAffinityMask = 1
> or CPUAffinityMask=2. Each change I restart the machine.
> 2. Uninstall Firebird 1.5.3 Super Server and Install Firebird 1.5.3
> Classic Server.
>
> Both way also can't help. Does anybody has the experience? Please
> advice. Thank you.
>
> _
> _,___