I installed a new version of n8n ([email protected]) but found that iterative data writing to MS SQL database doesn’t work. I have 10 similar WorkFlows and none of them works. The problem is somewhere in part “SplitInBatches-FunctionItem-MS SQL (call storedProcedure)”. WorkFlow also burns all available CPU resources and 3.6GiB of RAM.
The latest working version is 107.0. With this version, it took 30 seconds to save 1000 record to the database =>33 records/second. With 108.0 and later, it stores 1 record/second and after 30second everything stops. After a certain time, the status in the log changes from running to Unknown.
Resources [email protected] (55% CPU + 5% RAM (385MiB))