I have a WorkFlow that gets a lot of data (1000 records) in an array. Then I want to write the data to MS SQL in a SplitInBatches loop. After some time I get a browser message “This page isn’t responding”.
I have prepared an example that simulates the behaviour of my production WorkFlow.
CreateArray => makes an array with 1000 records.
FunctionDelay => simulates writing to the database => makes a 20 ms delay.
What is interesting is that if I increase the delay from 20 ms to 50 ms I see “progress arrows” inside the WorkFlow for some time.
I have the sample workflow running now, While I am waiting to see if the error reproduces can you tell me a bit more about the setup you have? The information we request in the template when creating a new question is very handy.
Information on your n8n setup
n8n version:
Database you’re using (default: SQLite):
Running n8n with the execution process [own(default), main]:
Running n8n via [Docker, npm, n8n.cloud, desktop app]: