Comments (3)
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.
Related Issues (20)
- Installer v1.7.2 and Visual Studio 2017 (15.5.5) /SSDT 15.1.61710.120 - Does not appear in SSIS Toolbox HOT 1
- Cannot selectively choose hash columns HOT 6
- Installation to Azure SSIS runtime HOT 7
- Packages fail to run on server HOT 3
- Extending the component HOT 1
- Installation location of Multiple Hash transform non-default SQL Server install location HOT 8
- No Setup.exe file in the download SSISMHash.zip. How do I install? HOT 2
- Anyway to migrate from 2008 to 2017 ? HOT 2
- SQL Server 2019 Support HOT 4
- Installer not compatible error HOT 1
- MultiHash 64 not working on SQL Server 2019 HOT 1
- Incorrect version showing in About menu HOT 4
- v1.7.5.0 is unsigned HOT 1
- Support SQL Server 2022 HOT 3
- Sha2(512) Value different in ADF/Snowflake than in SSIS HOT 1
- SSDT 17.2 compatibility HOT 3
- Proper location for Install for SSDT 2015 HOT 4
- SQL 2016 SP1 Support HOT 2
- Installer issue v1.7.2 - Not showing up in 140>DTS HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ssismhash.