Slow database queries

New home Forums Gold Add-on Troubleshooting Slow database queries

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #57543
    pbradl42
    Member

    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?

    #57544
    pbradl42
    Member

    Attachments didn’t work.

    #57545
    pbradl42
    Member

    Trying attachments again

    Attachments:
    You must be logged in to view attached files.
    #57547
    pbradl42
    Member

    OK, so it looks you can’t attach 2 files to a post.

    Attachments:
    You must be logged in to view attached files.
    #57591
    Perry
    Moderator

    Hi there

    Thank you for getting in touch, sorry to hear you’re experiencing performance issues.

    Please can you go to Maps -> Advanced and run an export then send us the resulting JSON file?

    I’d like to simulate your data at our end and see how we can speed that up.

    We’ll run tests at our end today to see if we can optimize this at all.

    I do beg your pardon for any inconvenience caused.

    Kind regards
    – Perry

Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.