Slow database queries

New home › Forums › Gold Add-on › Troubleshooting › Slow database queries

Tagged: 

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • January 28, 2020 at 2:47 am #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?

    January 28, 2020 at 2:49 am #57544
    pbradl42
    Member

    Attachments didn’t work.

    January 28, 2020 at 2:50 am #57545
    pbradl42
    Member

    Trying attachments again

    Attachments:
    You must be logged in to view attached files.
    January 28, 2020 at 2:51 am #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.
    January 29, 2020 at 9:36 am #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

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