NickC4555
Active Member
I have a member news list which looks up 5 values from the master members list to display in the news list view. 3 of the values are used for filters, so I have separate (1 database join, 2 calc) elements for those, the other 2 are retrieved in a single query in a calc element. This seems massively inefficient as I assume 4 queries are run for each row. Is there a better was of doing this? It would be great to be able to get values for multiple elements with a single database join element, better still to somehow run 1 query per page.
The page is currently logging:
10 rows 75 queries
100 rows 345 queries
I have tried using a list join, but that writes back to the master table when a news item is created.
I would be grateful for any suggestions.
The page is currently logging:
10 rows 75 queries
100 rows 345 queries
I have tried using a list join, but that writes back to the master table when a news item is created.
I would be grateful for any suggestions.
Last edited: