ExtSort with CloverETL

could you indicate to me the exact significance of the option “Sorter Initial Capacity” of the component Ext Sort ?

The ExtSort component is described (among others) in Components overview document → see http://cloveretl.berlios.de/docs/Clover … nents.html

In short:
initial capacity of internal buffer used for in-memory sorting records. If the system has plenty of memory, specify high number here (5000 or more). If the system is short on memory, use low number (100).

The final capacity is based on following formula:
sorter_initial_capacity * (1 - grow_factor^max_num_collections)/(1 - grow_factor)

where:
grow_factor=1.6
max_num_collections=8

David.