Hello again Mike,
I’m sorry that the issue still has an impact on you.
I see that you are still using an older version of PRO. We are currently at version 4.4.24.2 and since 4.4.21 we have made improvements in the code and queries to make the geolocation queries more performant / less resource intensive. So far the responses from our users have been positive.
I would kindly like to ask you to check how the new versions of the plugins perform on your multi-site.
I’m sure you are playing it safe, nonetheless, let me suggest that you try them out on a staging site first, or at least create a full backup of your site, files and database including.
If the update doesn’t solve it, then I’ll try to get another solution for you to somehow eliminate the queries in question.
Cheers,
Andras