very slow DB Query Reader

Hello Community,

From one day to the other the SQL script became very slow executed via DB Query Reader in KNIME.

When I executed the same script in SQL Server MS it returns the results within no time. The returned table contains only 1-2 rows.

I did not changed anything in the script so I do not know how to find the rootcause for such degradation in execution time.

Do you have any idea what to check in KNIME?

Hello @andraskriston,

you run the DB Query Reader node on you local machine, correct? Which KNIME version are you using?
We could try to see whether the logs have additional information. To open the logs you need to click on “View” on the top left corner and then “Open KNIME log”. Can you paste the log information here after you executed the DB Query Reader node?

Best regards
Jörg

1 Like