Thanks, Ray!
But this is very strange. The length of constraints is about 1K. The condition is simle, it check the equality of string in DB and inut string and works wrong (debuger shows identical values, Ardent considers conversly).
I dontt think that in our case (Sun Enterprise 3500, 2Gb Ram,
IDS.2000) performance is determined by external factors. The simple row update in the 50000 records table longs more then 1 second!!. While queries produced by dbaccess, Business Objects are executed with normal speed.
May be you know any tools, methods, etc to monitor Ardent perfomance and find bottleneck?
Alexandre
RW> There is a limit (undocumented, but mentioned in the past on this
RW> list) of 8K bytes for any expression in DataStage. If its getting
RW> near this limit (say over 6K bytes, since column names are re-mapped
RW> when the expression is compiled), consider replacing the expression
RW> with a call to a Routine (transform function).
RW> In the "Advanced DataStage" class offered in Asia-Pacific region
RW> there is a module on the topic "Designing for Performance". This is
RW> the only resource of which I am aware.
RW> The main performance issues typically are external factors, such as
RW> available (rather than theoretical) network bandwidth, database
RW> server performance and hardware performance. Of course, inefficient
RW> coding practices in DataStage will never help!
RW> -----Original Message-----
RW> From: Alexandre Stoulov [mailto:alexs@tern.ru]
RW> Sent: Monday, 02 April 2001 18:24
RW> To: informix-datastage@oliver.com
RW> Subject: Some questions
Best regards,Alexandre Stoulov
------------------------------
TERN Technical Support
mailto:alexs@tern.ru
Re[2]: Some DataStage questions
Alexandre,
The simple row update in the 50000 records table longs more then 1 second!!. I had one like this on an Oracle data base. Nearly drove me spare until I discovered that the index on the primary key was busted.
Just because it looks the same doesnt mean it is. Problems can be: . embeded unprintable chars, . Additional spaces Begining, Middle or End
Thanks Jack
----- Original Message -----
From: "Alexandre Stoulov"
To: "Ray Wurlod"
Sent: Monday, April 02, 2001 6:54 PM
Subject: Re[2]: Some DataStage questions
> Thanks, Ray!
>
> But this is very strange. The length of constraints is about 1K. The
> condition is simle, it check the equality of string in DB and inut
> string and works wrong (debuger shows identical values, Ardent
> considers conversly).
>
> I dontt think that in our case (Sun Enterprise 3500, 2Gb Ram,
> IDS.2000) performance is determined by external factors. The simple
> row update in the 50000 records table longs more then 1 second!!.
> While queries produced by dbaccess, Business Objects are executed with
> normal speed.
>
> May be you know any tools, methods, etc to monitor Ardent perfomance
> and
find
> bottleneck?
>
> Alexandre
>
> RW> There is a limit (undocumented, but mentioned in the past on this
list) of
> RW> 8K bytes for any expression in DataStage.
> RW> If its getting near this limit (say over 6K bytes, since column
> RW> names
are
> RW> re-mapped when the expression is compiled), consider replacing the
> RW> expression with a call to a Routine (transform function).
>
> RW> In the "Advanced DataStage" class offered in Asia-Pacific region
> RW> there
is a
> RW> module on the topic "Designing for Performance". This is the only
resource
> RW> of which I am aware.
>
> RW> The main performance issues typically are external factors, such
> RW> as available (rather than theoretical) network bandwidth, database
> RW> server performance and hardware performance. Of course,
> RW> inefficient coding practices in DataStage will never help!
>
> RW> -----Original Message-----
> RW> From: Alexandre Stoulov [mailto:alexs@tern.ru]
> RW> Sent: Monday, 02 April 2001 18:24
> RW> To: informix-datastage@oliver.com
> RW> Subject: Some questions
>
>
>
>
>
> Best regards,Alexandre Stoulov
> ------------------------------
> TERN Technical Support
> mailto:alexs@tern.ru
>
>
The simple row update in the 50000 records table longs more then 1 second!!. I had one like this on an Oracle data base. Nearly drove me spare until I discovered that the index on the primary key was busted.
Just because it looks the same doesnt mean it is. Problems can be: . embeded unprintable chars, . Additional spaces Begining, Middle or End
Thanks Jack
----- Original Message -----
From: "Alexandre Stoulov"
To: "Ray Wurlod"
Sent: Monday, April 02, 2001 6:54 PM
Subject: Re[2]: Some DataStage questions
> Thanks, Ray!
>
> But this is very strange. The length of constraints is about 1K. The
> condition is simle, it check the equality of string in DB and inut
> string and works wrong (debuger shows identical values, Ardent
> considers conversly).
>
> I dontt think that in our case (Sun Enterprise 3500, 2Gb Ram,
> IDS.2000) performance is determined by external factors. The simple
> row update in the 50000 records table longs more then 1 second!!.
> While queries produced by dbaccess, Business Objects are executed with
> normal speed.
>
> May be you know any tools, methods, etc to monitor Ardent perfomance
> and
find
> bottleneck?
>
> Alexandre
>
> RW> There is a limit (undocumented, but mentioned in the past on this
list) of
> RW> 8K bytes for any expression in DataStage.
> RW> If its getting near this limit (say over 6K bytes, since column
> RW> names
are
> RW> re-mapped when the expression is compiled), consider replacing the
> RW> expression with a call to a Routine (transform function).
>
> RW> In the "Advanced DataStage" class offered in Asia-Pacific region
> RW> there
is a
> RW> module on the topic "Designing for Performance". This is the only
resource
> RW> of which I am aware.
>
> RW> The main performance issues typically are external factors, such
> RW> as available (rather than theoretical) network bandwidth, database
> RW> server performance and hardware performance. Of course,
> RW> inefficient coding practices in DataStage will never help!
>
> RW> -----Original Message-----
> RW> From: Alexandre Stoulov [mailto:alexs@tern.ru]
> RW> Sent: Monday, 02 April 2001 18:24
> RW> To: informix-datastage@oliver.com
> RW> Subject: Some questions
>
>
>
>
>
> Best regards,Alexandre Stoulov
> ------------------------------
> TERN Technical Support
> mailto:alexs@tern.ru
>
>