Hi there!
I'm pretty new to retool, and I'm struggling to setting up a scheduled workflow, which have to iterate over a large amount of data and batch operations.
According to the documentation, asynchronous workflows have up to 30h to succeed, while synchronous workflow have up to 15 minutes
So I made a workflow which is getting the count of entities and then pass it to a function which iterate entities by 200 and await the resolution of the current set operations before to pass to the next iteration
I thought it would ends up in an asynchronous workflow, since the execute bloc resolve immediatly and the logic is executed in another process
So to test it, i setted an await promise résolution with a settimeout of ~17 minute in the called function (to check if my worflow would be timedout)
And the worflow is timedout while every blocs were executed quickly as expected
So the workflow isn't considered asynchronous at all
What am i missing in my implementation?
Is it possible to set an asynchronous scheduled workflow?
What I tried:
-Set a responseBloc before the js bloc in the chain, but the workflow is still timedout after 15 minutes while response block is executed immediatly
-Even if it's not adapted to my case, I tried to make a parallel process as explained here for a webhook implementation, but the workflow is still timedout after 15 minutes