I have a general 'good practice' question.
I have a multisite network with subdomains. There will be probably about a dozen subdomains when I am done, not more. The traffic on each site is low, I don't expect the network to reach over a few thousand unique visitors a day.
Some of the subdomains are mapped to domains since they are individual project websites.
Some domains contain only, for example, a media library or a database of organizations, another contains news etc. Each piece of content is created only once in the network and tagged in a specific way to denote where it should be shown. The other sites then query the content by the tags and output it.
Currently the querying is done by switch_to_blog -> do a query -> foreach -> setup_postdata -> output the necessary information.
My question is: how resource efficient is this type of querying and is there a more efficient way to do this? I have little experience with code outside WordPress which is why I have chosen this solution instead of building things from scratch and I would like to keep it as WP because it is so incredibly convenient.