hello,
i'm looking for some ways to improve performance of Aggregator Stage.
But i didn't find any options to say to DS that my source is already sorted (i use an order by sql clause) like in DS 5.0 Server where there was such options (i used to use it !)
Thank you
Chanthou
how can i improve performance in Aggregator
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 11
- Joined: Mon Jun 16, 2003 2:21 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The options for specifying sorted input are in the Columns grid in server job Aggregator stages.
In parallel stages, sorting of input is managed as a property of the input link; I don't have access to PX at the moment to give you specifics, but it's certainly possible.
In parallel stages, sorting of input is managed as a property of the input link; I don't have access to PX at the moment to give you specifics, but it's certainly possible.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
In the aggregator stage there is in the option section wherein you could select the method to be sort instead of hash.
Now before you run into this aggregator use a sort stage and sort it on the the grouping keys of the aggregator.
The partitioning into the sort stage hash it on the grouping keys and into the aggregator keep it auto.
try this and I am sure you would have better performance gain.
Any questions let me know.
Now before you run into this aggregator use a sort stage and sort it on the the grouping keys of the aggregator.
The partitioning into the sort stage hash it on the grouping keys and into the aggregator keep it auto.
try this and I am sure you would have better performance gain.
Any questions let me know.
shravan