There is a new KNIME forum. You can still browse and read content from our old forum but if you want to create new posts or join ongoing discussions, please visit our new KNIME forum: https://forum.knime.com

Waiting Too Long While Fetching 100 Rows Data from Database

Member for

2 years 5 months mozturkmen

Hi,

 

I am relatively a new Knime user. It is an excellent product. As soon as possible, when I learn Java programming I will make contributions to the platform. 

For now, I have a problem. I am connected to Oracle database. When ı first open my workflow, I can run a table connection node. But after that, when I want to  connect different database tables, I am waiting too long. When I want to fetch only 100 rows from database I am waiting too long. My memory preference is "keep only small size"... Also when I want to write table to database, I am waiting too long and at last, it does not writes to table. Node says that: "opening database connection"...

 

How can I solve this problem? 

So many thanks...

Comments