Wu question - database access in an RG

[1theritzy]

Is this correct, if Input 1 inside an RG uses a user field 1 for its initial content, and that Input is repeated 30 times in the RG, does that mean the database is accessed 30 times, one data retrieval for every row? (for wu calculation)

What I am pondering is if I set up a 2nd input outside the RG, set the 2nd input initial content to user field 1 and then Input 1 in the RG initial content is set to Input 2, then the user field 1 is only retrieved one time, and I get the same end result of user field 1 in Input 1 and 30 times less wu.

Is that correct?

[georgecollier]

@1theritzy

RG uses a user field 1 for its initial content, and that Input is repeated 30 times in the RG, does that mean the database is accessed 30 times, one data retrieval for every row? (for wu calculation)

Roughly speaking yeah, unless it’s the same user in each row (you won’t be charged multiple times to access the same user because it’s already been fetched).

@1theritzy

What I am pondering is if I set up a 2nd input outside the RG, set the 2nd input initial content to user field 1 and then Input 1 in the RG initial content is set to Input 2, then the user field 1 is only retrieved one time, and I get the same end result of user field 1 in Input 1 and 30 times less wu.

I believe that because of the above, your workaround won’t actually make a difference

[1theritzy]

Interesting, thanks George. That helps.

Yes, it’s the same user field in each row. How about for speed difference or best practice, is the answer the same?

[georgecollier]

@1theritzy

How about for speed difference or best practice, is the answer the same?

No difference, behind the scenes the requests to the server are the same (1x request to server for the Thing). I’d keep it in the repeating group.

[1theritzy]

very good, thanks for all George.