AnsweredAssumed Answered

Best Practices: One Query & Variables or Direct List Lookups

Question asked by tast on Mar 29, 2017
Latest reply on Mar 29, 2017 by tast

So I have a lot of places where I am setting data for a particular item. Generally there is a certain set of data from an item that I need. So my tasks end up with a lot of these:

 

 

 

Would it be better performance wise to do one query and set all these into variables? 

 

Would this reduce from three queries to 2? In the above case?  (I am aware the pictures don't line up just an example of a query setting three values vs list lookups for each value?  

 

Also what about in the case of ItemProperty? Is it better to do a query as above or just to use ItemProperty lookup?

 

Outcomes