When I want to delete certain rows from a database table, the corresponding KNIME node is terribly slow. Is there an option for the knime.ini that speeds it up, just like the one for the Database Reader node (-Dknime.database.fetchsize)?
I already tried to search for such an Option below Help -> Help Contents, but then I get an HTTP 500 error.
I think that there is a ‘Batch size’ option on the advanced tab, which will have this effect - see https://nodepit.com/node/org.knime.base.node.io.database.DBDeleteRowsNodeFactory#advanced
Steve
You are right, Steve, this option has a certain effect. But the execution still takes very long even for 10k rows.
Performance obviously will also depend on the WHERE columns chosen in the dialog and if they are indexed or not and the size of the total database.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.