CoSort Version 9

IBM p570, using just 2 of 6 available CPUs @ 2.1GHz

Infile Size	Prior Version	v9.1
~1GB	40s	20s
~2GB	1m 20s	30s
~6GB	5m 10s	2m 50s

Third-party observations:

1) 2x better performance with same resources consumed
2) Pre-sort job scripts are no longer required for joins
3) Detail and summary aggregation performance also improved
4) Performance can be affected by many factors, including:

• Data types, volume and layout
• Number and location of sort keys
• Other running applications
• System and CoSort tuning
• CPUs, cores, RAM and overflow disk
• Other functions in the job script

With these factors largely undefined below, consider:

CoSort Version 8

SunFire15K w/6 CPUs, 2.4GB in 39 seconds
IBM p690 w/4 CPUs, 1GB in 12 seconds
Linux Itanium w/4 CPUs, 5GB in < 6 minutes
HP N440 w/8 CPUs, 50GB in 49 minutes
Compaq GS140/8, 1.8 GB in 67 seconds

CoSort Version 7

AlphaServer 4100 w/4 300Mhz CPUs, 1GB in 58 seconds
IBM (Sequent) Numa Q-2000 w/4 CPUs, 272GB in 114 minutes
P200/2 w/ NT, 2 keys, 19 MB in 2 seconds
Sun UE3000, 23 keys, 5.2 GB in 20 minutes