Forum Discussion
Multiple queries in a dataflow executed sequentially or parallel?
Hi all,
I'm connected to an operational databases which limits the amount of parallel connections it handles to about 10. Any more connection gets a timeout.
If I create a dataflow with 20 queries in it, will these be executed to the database sequentially (one at a time) or parallel (everything shoots at once)?
Hey!
It depends on how you setup your queries, but by default they just run in parallel. However, if the execution of one of your queries depends on the result of a previous one, then that will need to be executed before that evaluation happens.
1 Reply
Hey!
It depends on how you setup your queries, but by default they just run in parallel. However, if the execution of one of your queries depends on the result of a previous one, then that will need to be executed before that evaluation happens.