Multiple queries in a dataflow executed sequentially or parallel?

[Noeleke1301]

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)?

[miguel · Accepted solution]

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.