Subject Re: [firebird-support] IBO, DataPump and Xeon with HT
Author Daniel Rail

At September 11, 2003, 10:22, Marco Lauria wrote:
> Hello I encountered a strange problem
> under my new machine a Xeon 2.8 with HT Enabled.
> I run the tests with FB 1.03 and FB 1.5 RC4 under Windows XP with latest
> Service Pack and latest Fixes.
> Everything works well when I use my application written using IBO
> but when I use the DataPump function,
> everything hangs up and it transfer data at 6 records per second using FB
> 1.03 and 25 records per seconds using FB 1.5.

This doesn't surprise me, the thread scheduler was improved in FB 1.5,
but still not ready for HT.

> The code with no HT Enabled runs really faster.

That is expected. I think it's in the release notes. You probably
would have better performance using Classic Server.

> I used CPU Affinity to set first CPU 0 and after CPU 1 and from the Task
> Manager I can see
> that the FB process has the right affinity (I dunno threads but AFAIK
> child-threads should use the same affinity as the main
> thread).

If not mistaken, Windows XP operates differently with HT CPUs than
with Windows 2000. So, the CPU affinity might not work as expected.

> P.S. I don't understand if this is related to IBO or to FB so I am
> cross-posting on both ibobjects and firebird-support
> lists.

It's FB related.

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (