Hi,

At September 11, 2003, 14:10, Marco Lauria wrote:

> After that I wrote this message, I tried to run the datapump from
> another machine using the Xeon as database server for both the
> source and the destination DB and everything went well, so this
> problem happens only when I run my BCB 6.0 or Deplhi Application on
> the same machine of the database server [Xeon 2.8 with HT enabled].

> Daniel Rail told me in firebird-support that the problem is related
> to FB but the fact that the problem doesn't happen if I run the
> datapump program on another machine let me imagine that the problem
> isn't firebird. Also When I run the program from the other machine
> and I trace with the Task Manager the two CPUs only the CPU where I
> set the affinity for Firebird has a high usage....

> I have no idea what can cause this...
> only I can tell you that the problem is present in both your
> datapump component and in DBAK.

What about setting the CPU affinity in your application? The API call
SetProcessAffinityMask is available in Delphi and BCB, and is only
available for WinNT/2000/XP/2003. It might be possible that your
application is creating a few threads that is causing this performance
degradation. Have you checked the stats in Task Manager regarding
your application, when HT is enabled?

It wouldn't hurt to try.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)