Subject | Re: [IBO] Data Pump Problem |
---|---|
Author | Marco Lauria |
Post date | 2003-09-11T17:10:33Z |
At 09:49 11/09/2003 -0700, you 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.
The code with no HT Enabled runs really faster.
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).
I'd like to know if someone else has this problem....
Note that If I run exports, imports everything goes well, the problem came
only when I use Datapump with two different
connections.
Thanks in advance
Marco
----------------
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.
Regards
Marco
Marco Lauria
STARMAX s.a.s.
TEL. +39-091-6880476
FAX. +39-091-6887202
MOB. +39-348-3547034
[Non-text portions of this message have been removed]
> > I tried to do the data pumpThis message arrived only on firebird-support:
> > from another machine using as source and destination two databases on the
> > Xeon Machine
> > with HyperThreading enabled and with my surprise the data pump
> > and the Backup using DBak Components of Geoff worked smoothlessy...
> > so now I'm more and more confused as I think it can't be an FB Related
> > problem....
>
>What problem are you referring to?
------------------
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.
The code with no HT Enabled runs really faster.
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).
I'd like to know if someone else has this problem....
Note that If I run exports, imports everything goes well, the problem came
only when I use Datapump with two different
connections.
Thanks in advance
Marco
----------------
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.
Regards
Marco
>Jason WhartonBest Regards,
>
>
>
>Yahoo! Groups Sponsor
>ADVERTISEMENT
><http://rd.yahoo.com/M=244522.3707890.4968055.1261774/D=egroupweb/S=1705007183:HM/A=1595056/R=0/SIG=124p07ne0/*http://ashnin.com/clk/muryutaitakenattogyo?YH=3707890&yhad=1595056>11926f81.jpg
>11927144.jpg
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
><http://www.ibobjects.com>http://www.ibobjects.com - your IBO community
>resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to the
><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.
Marco Lauria
STARMAX s.a.s.
TEL. +39-091-6880476
FAX. +39-091-6887202
MOB. +39-348-3547034
[Non-text portions of this message have been removed]