I’m trying to track down slow queries. Here’s the report of slow queries from QueryMonitor – from this page: https://deliberately.college/browse/colleges-by-state/colleges_by_alabama/
I’ve turned off the ‘Enable Category Count’ overall and ‘Filter by category’ on the specific map. I’ve even set it to read from an XML file, but that doesn’t seem to have any effect.
Can I either (a) optimize the table to speed up these queries, or (b) move the wpgmza tables to a different database (i.e. AWS or Google Cloud) to move the load off of my WP server database?