DB Insert very slow on one computer

KNIME Analytics Platform
1

I am migrating workflows from one computer to another.

  • On my first machine, I have a workflow that is currently outputting 15k rows with 4 columns and it finishes inserting into a db table in about a minute or less.
  • On my second machine with better hardware, DB Insert takes more than 10 minutes to do the same job with the same data. It does finish but each batch takes a very long time regardless of batch size.

I have several machines where, in the past, I have moved workflows around in the same way and never had issues.
There is nothing obvious wrong that I can see.

Is there something I may have missed that someone can point out?

I suspect it may be related to the machine or network, but how would I troubleshoot this? What is the best way to start looking into this? Since there is no error here, I assume there is not much on Knime’s side that I can do right?

2

Did you by chance modify the available memory in one version of the Analytics Platform and notht the new machine?

2 Likes
3

No, I have not tried changing that before.
And increasing it now doesn’t seem to make a significant difference on the new machine.
Thank you

1 Like