Hi!
I have a problem with a very very slow spreasheet node. I
Describe the issue/error/question
After uncompressing zip file to csv I want to retrieve items with Spreadsheet node. The spreadsheet node don’t work. I let it work 1 hour and nothing, still processing. Can’t stop execution, error 514.
CSV file is huge (600k lines, 80mb size) but it works well for a half size file (around 300k).
Ram used : around 4gb and CPU around 25%
Server : 16 GB Memory / 8 AMD vCPUs
What is the error message (if any)?
No error (console/front)
Please share the workflow
Information on your n8n setup
- **n8n version: 0.194.0
- **Database you’re using (default: SQLite): PostgreSQL
- **Running n8n with the execution process [own(default), main]: own
- **Running n8n via [Docker, npm, n8n.cloud, desktop app]: CapRover
N8N_DEFAULT_BINARY_DATA_MODE : filesystem
If you have some tips to improve performance or how to split csv file on N8N.
Thank you very much