GitHub user bamaer added a comment to the discussion: What is best approach instead of DB lookup?
Have you looked at the merge join transform? Also: DB Lookup can be fast if you enable caching, but caching requires memory. As a rule of thumb: lookups only get the first matching record, join transforms (merge join, database join etc) can generate new records if multiple matches are found. GitHub link: https://github.com/apache/hop/discussions/6136#discussioncomment-15178975 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
