MaybeLexter commented on issue #9587:
URL: https://github.com/apache/hop/issues/9587#issuecomment-7020633302

   Would it be possible to buffer incoming rows, similar to how some transforms 
collect rows before processing them?
   
   For example, with a batch size of 1,000, the transform could buffer up to 
1,000 rows, fetch exactly 1,000 NEXTVAL values, assign them to the buffered 
rows, and then continue.
   
   When the input ends, it could fetch only the number of sequence values 
needed for the remaining rows.
   
   This would reduce database round trips without reserving unnecessary 
sequence values for the last batch.
   
   I understand that Oracle sequences can still have gaps due to caching, 
rollbacks, or concurrent executions. That's not an issue for this use case.


-- 
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]

Reply via email to