Enabled all data in memory

Hi, I used knime to operate MySQL, and enabled all data in memory, disabled compression features and set up batch size to 2000.
But I still found database writer performance is messed.
I deployed knime with MySQL by 10Gb network.

Hi there!

Welcome to KNIME community!

When you say messed what do you mean? It takes long? If yes how long and how many records are you writing to your database? Everything else works as expected?

Enabling all data in memory requires a lot of memory assigned to KNIME. Have you done that?

Additionally if you are not using new database Integration nodes you can give them a try. They are supposed to be production ready with the next summer release.

Br,
Ivan