Subject Re: [firebird-support] Very slow FB access
Author Alexandre Benson Smith
Joe Martinez wrote:
> We have a customer who just upgraded their PC, and is getting very
> slow FB access (FB 1.0) on the new machine. We have tried everything
> we can think of, and can't figure out why this new very fast machine
> is so slow when talking to the FB database.
>
> Here are the specs that they guy who built the system sent to us:
>
> 160GB 7200 RPM Sata 3.0Gb/s Western Digital Hard Drive
> 2GB (2 x 1GB) 240-Pin DDR2 SDRAM DDR2 800 (PC2 6400) Dual Channel
> Vista Business SP1 32-bit English
> Asus P5QL-E LGA 775 Intel P43 ATX Intel Motherboard (Audio, Lan)
> ASUS EN6200LE/TC256/TD/64 GeForce 6200LE 256 MB 32-bit DDR PCI-Express
> x 16
> video card
> Intel Pentium E2180 Allendale 2.0Ghz LGA 775 65W Dual-Core Processor
>
> When we go into the My Computer properties, the processor is listed as:
> Intel(R) Pentium(R) Dual CPU E2180 @ 2.00GHz 2.00 GHz
>
> The only thing that I could think of was the "affinity" issue that
> I've read about on here, when the machine had more than one CPU, which
> we have never dealt with, but the tech says that the machine does not
> have two CPU's, and that it's just a dual core CPU. We have never had
> a problem with Intel dual core CPU's before.
>
> Any ideas?
>
> We may give the affinity switch a try, just to see if that fixes it,
> but I don't know where to set that. Can anyone tell me?
>
> -Joe
>

A dualcore is 2 CPU's inside a single wafer of silicon.

Use CS that would perform better, remember to set the database cache
size to 75 (the default value).

Look on the task manager to see if the fbserver process bounce between
the CPU's.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br