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]
