How can we improve the newest version of Windward Studios Products?

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.

6 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
John shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base