mhamedbenjmaa opened a new issue, #6885: URL: https://github.com/apache/hop/issues/6885
### What would you like to happen? Hello As you know, upsert is super time consuming, i have simple example 200k rows takes approx 49 sec (capture 1) <img width="2001" height="437" alt="Image" src="https://github.com/user-attachments/assets/7136673e-0ed7-42d4-819a-b8da5ea4853b"; /> the best practice for huge table is to go through hash and just update when hash is different instead of comparing all fields see capture 2 we go from 49 to 2 sec for the exact same table and the exact same fields , this is as you know is widely common practice , but as you can see in capture 2 it take longer to devellop and all pipeline builder do this manually because of performance <img width="1973" height="546" alt="Image" src="https://github.com/user-attachments/assets/b4cadc8b-cd82-4f55-af95-03a61baf2b9b"; /> it would be super nice to have a tab or any way to simplify this the UI woulds ask do you want to use hash for change validation? if yes ? what hash type ? whats the column name source (optional , if any calculated on the fly if not provided) whats the destination column (not optional) this would be a killing feature ! 3 option to fill up instead of a entire dev nice isn't it ? ### Issue Priority Priority: 2 ### Issue Component Component: Transforms -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
