I'm looking for a way to save database queries on one of my sports sites.
This is how it works currently.
There are 2 custom types involved here. One is "competitors" and other is "tournaments".
Then there is a ranking based on how many points each competitor received on each tournament.
What I did was adding a custom meta box on the "tournaments" post type that allows to write a value for each person that participated in (these can be added dinamycally to the meta box).
Now, on the rankings page, I need to loop through each posted competiror and then get the total value they have on each tournament (which I now do by doing another wp_query using the corresponding meta query).
This means that each person requires a wp_query. Now it's not a problem (only 80 registeed competitors), but if more keeps being added, the number of queries will be huge.
Also, since I cannot know the position in the ranking until I have added everything for everyone, a php paging would be imposible (only a jquery one that doesn't make a difference here).
The meta key is something like competitor_X (X being the post id of the competitor)