Running multiple database queries at a time in microflow

1
i have clsoe to 1000 queries to be run on a database. If  i run them through loop, it will run them serially and will take a lot of time to complete.  Our servers can handle multiple runs , so at a time we can run at least 20-30 , so how do we run database queries parallel , any suggestion on how to do this using microflow
asked
1 answers
2

Hi JP,

I would advise to use some form of Queuing. As of Mendix 9 an out-of-the-box Task Queue is available, you can make a loop which adds 1000 jobs to the same queue. In the properties of the queue, you can set how many processes may run in parallel. See example setup in screenshots below.

 

I see, you are using Mendix 8.18; would upgrading be an issue? Expected end-of-life of Mendix 8 is june 2025, so upgrading is needed at some point...

 

 

answered