I got some issues with the speed to query data from Oracle DB.
I use Database Reader (Legacy) to query data from a database. It is very very slow…you can see the pics I attached (or it was about Caching row setting?) …So, can we have the way to speed it up or any way to do? Please help.
have you tried the new DB Framework? It even has dedicated Oracle Connector node.
Could you use the non-legacy versions? Deprecated or Legacy nodes tend to be slower, but it’s a case-by-case basis.
@cppong you could try and read the data in chunks like in this example:
Hi Victor @victor_palacios
Thanks for the advice.
As I checked, I didn’t see the non-legacy for the Database Connector node. So, how I can get that node? See my captured pics.
I use KNIME version 4.2.0
Never try this before. Thanks a lot @ipazin
Thanks a lot @mlauber71 for an example of the script.
KNIME has gotten an overhaul of the DB framework with version 4.1. The nodes also got new names, they’re now called “DB something”:
You should update to the newest version your company allows you to. There’re new features, more speed and, most importantly: easier support on the forum
Also, as a general rule, versions x.y.0 should not be used for production purposes. Those version focus on new features and thus have the highest risk of introducing undetected bugs. source:
Thanks so much @Thyme I had checked it and found the database name will be DB… as you shown in the pics.
@ipazin Bingo !! I found the new DB version (instead use Legacy) & implemented all the DB connectors & SQL reader. It’s very fast to query. My problem was solved now. Thanks again and thanks to others for the great help!
Thanks for all of your help. It solved now ^^
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.