Tsort vs. Syncsort
Posted: Wed Dec 03, 2003 2:20 pm
All-
I used to believe that tsort was faster than sycnsort most of the time, but from the recent posts, I'm wondering which is truly faster.
Maybe this community can come up with a heuristic for determing when to use each sort. To do this, I propose that PX users post sort statistics, and then we can analyze the stats and come up with some generalizations.
Here are the stats to post:
1. Type of Sort (sync or t):
2. Type of file in (dataset, flat file, etc):
3. Type of file out (dataset, flat file, etc):
4. Version of PX:
5. Version, flavor of UNIX:
6. Gbs scratchdisk:
7. Gbs swap space:
8. # Cpus:
9. # Partitions:
10. Amount of time it took for the sort to run:
And any other stat you think would be useful in this analysis.
Thanks,
BP
I used to believe that tsort was faster than sycnsort most of the time, but from the recent posts, I'm wondering which is truly faster.
Maybe this community can come up with a heuristic for determing when to use each sort. To do this, I propose that PX users post sort statistics, and then we can analyze the stats and come up with some generalizations.
Here are the stats to post:
1. Type of Sort (sync or t):
2. Type of file in (dataset, flat file, etc):
3. Type of file out (dataset, flat file, etc):
4. Version of PX:
5. Version, flavor of UNIX:
6. Gbs scratchdisk:
7. Gbs swap space:
8. # Cpus:
9. # Partitions:
10. Amount of time it took for the sort to run:
And any other stat you think would be useful in this analysis.
Thanks,
BP