I’ve started using the DB Loader node. It’s a big performance improvement in comparison with other approaches. Since I introduced it, I can write 5,5M rows table in less than 3 minutes which is huge.
Today I faced a situation the data saving failed with a message:
2020-01-13 13:08:20,574 ERROR DB Loader 0:836 The input and database columns do not match. 4 columns are different:
2020-01-13 13:08:20,576 ERROR DB Loader 0:836 The input column type at index 16 is “INTEGER”, the database column type is “SMALLINT”.
There is actually a workaround I could change the database columns but I’d preffer avoiding that.
I’d appreciate any advice.