ForEach order='row' - Too Many Queries
When using a ForEach order=row inside another ForEach loop the number of queries performed multiplies e.g. If you have an outer ForEach loop which retrieves 5 entries, and an inner ForEach loop with order=row you get:
- Call to initial outer ForEach
- Call to initial outer ForEach
- Loop over each inner ForEach (5 calls)
- Call to initial out For Each
- Look over each inner ForEach (5 calls)
.. and so on until each entry in the Outer ForEach is resolved.
If you use legacy mode on the inner ForEach you get a single outer foreach call, and then 5 inner ForEach calls. This is six calls instead of 31 calls in the first example.
John
shared this idea
Hello Reporter,
We have reviewed this idea internally but have decided to decline it due to lack of votes. Thank you for your idea, and please submit any other suggestions you have to improve our products.
Adam Austin
Product Manager