This is a question of how BO 6.5.1 interacts with the back end RDBMS.
If there is a BO query that necessitates the use of multiple selects in what form is this sent to the database.
For example if the BO query produces 3 selects are these sent to the DB engine as one script or 3 separate scripts.
The reason I ask is that if it is the former my understanding is that the DB would execute each separate statement one after the other whereas if the latter applies then the selects will be run in parallel.
TIA for any answers.
![[bandito]](/data/assets/smilies/bandito.gif "[bandito] [bandito]")
[blue]DBomrrsm[/blue]
[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]
If there is a BO query that necessitates the use of multiple selects in what form is this sent to the database.
For example if the BO query produces 3 selects are these sent to the DB engine as one script or 3 separate scripts.
The reason I ask is that if it is the former my understanding is that the DB would execute each separate statement one after the other whereas if the latter applies then the selects will be run in parallel.
TIA for any answers.
[blue]DBomrrsm[/blue] [blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]