Hi all,
Was wondering about your thoughts on best practices or even documentation related to this.
I have a table with 30.000 records currently, it will potentially grow to a couple of millions. Every week I need to update this table via an external API request connected to an ERP using a TASK. The system's API is "old" and only allows 1 request at a time (So you can see how long this takes).
Was thinking from a point of view in XANO:
1. Will the TASK timeout at some point? Or will it run as long as it does not consume the server resources fully?
2. What are best practices to run this? Should I separate the task in chunks and run in different days of the week?
3. Should I run all data but apply a buffer /error method to it (Sleep, try/catch)?
Thank you very much in advance,