Possibility for a CustomProperty to specify numOfThreads about ssismhash HOT 3 OPEN

It is possible, and involves changes to around 6 functions, creation of a couple, and form modifications.
And then the regression testing to ensure nothing is broken.

I understand the use case of attempting to control the amount of CPU that the hashing will consume.

FYI.
Currently Auto will use cores - 1, IF there are more than 5 output columns in the component.
If there are less than 5 output columns, then the overhead of multiple threads exceeds the gain's that it provides.

from ssismhash.

Wait, so - output columns, not the number of input columns to hash.. I've misunderstood this then - if so then a single thread is just fine, as I'm just using 1 column per component anyways.

from ssismhash.

If you have a wide input (100 odd columns for example), and are generating 15 hash output columns (for example) from that, then On and Auto will improve the hashing performance. This is because 15 byte arrays are being created, and then hashed, for each input row. That can be done in parallel, to improve performance (a lot if you have enough cores).

If you have all of those columns into a single hash, then Auto will choose single thread, as it has to put all the columns into a single byte array and then hash that result.

The component has to work row by row, as it's a sync non blocking component.

It sound's like you don't need the enhancement.
And that I might need to improve the documentation on how Auto and On help performance...

from ssismhash.