[Bug]: Database join is taking longer to execute

[pramodgsable]

Apache Hop version?

2.8.0

Java version?

11

Operating system

Windows

What happened?

Steps to reproduce:

1. Create a pipe separated text input file and add some data with headers in it. (emp_id,ename,salary,dept)
2. create a oracle database table employee with fields emp_id, ename, salary, dept
3. create a pipeline to read data from the text file input
4. Add a database join transformation to the pipeline & save it.
   select
   emp_id
   , ename
   , salary
   from employee
   where emp_id = ?
   Parameter Field is emp_id (String) from the text file input
5. save & execute this pipeline
   The time it took was 9 min 42sec to execute the database join step (added screenshot for the similar database join transform showing execution time)

Issue Priority

Priority: 2

Issue Component

Component: Transforms

[bamaer]

did you enable caching and did you create an index on the emp_id column in your database?

[pramodgsable]

caching is not enable, also we have index on emp_id

[pramodgsable]

Similar sort of operations I tried using SQL Executor transform its pretty quick takes less than sec to complete

[pramodgsable]

I tried enabling the cache and indexing the table fields like emp_id still it is not performing well

[hansva]

.take-issue