Performance comparison b/n DataSet and Sequential File

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
inf_dev
Participant
Posts: 1
Joined: Thu Apr 29, 2004 11:47 pm

Performance comparison b/n DataSet and Sequential File

Post by inf_dev »

Hi,

I need to get a comparative analysis of the performance for jobs using DataSet stages to those using Sequential Files ( for similar set of conditions - viz, defined server, processors, data size etc).

Essentially quantitative facts are needed for this purpose as well.
Metrices available if any citing the difference in performance would also help.

Pls reply with pointers/ details if any ASAP.

Thanks and Regards,
NB
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Do you want to put any constraints on responses? For example, if you have an eight CPU configuration, then a response from a 32 CPU configuration would not be particularly useful to you; scalability is nearly linear, but not exactly. Are you talking about a single SMP system, or an MPP cluster?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply