Query load my database

This topic contains 1 reply, has 2 voices, and was last updated by  Alex Rollin 5 years ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • #516882

    Jorge Adrian Urrego Acosta
    Full Member
    Post count: 22

    Hello!!
    A few weeks ago (after update geodirectory) one query is loading my database, this runs many times in parallel. I think is related to sitemap generation (Yoast seo) but is a particular geodirectory table (maybe poor optimized). Please help me, my site is broken.

    wp_geodir_post_locations= 493 rows
    wp_geodir_gd_place_detail= 505104 Rows
    wp_posts =679706 Rows

    SELECT tt.term_id, MAX(p.post_modified_gmt) AS date_gmt, l.country_slug AS country, l.region_slug AS region FROM wp_geodir_post_locations l LEFT JOIN wp_geodir_gd_place_detail pd ON ( pd.country = l.country AND pd.region = l.region ) LEFT JOIN wp_posts p ON p.ID = pd.post_id LEFT JOIN 
    wp_term_relationships

    AS tr ON tr.object_id = p.ID LEFT JOIN

    wp_term_taxonomy

    AS tt ON ( tt.term_taxonomy_id = tr.term_taxonomy_id AND tt.taxonomy = 'gd_place_tags' ) WHERE p.post_type = 'gd_place' AND p.post_status = 'publish' AND l.location_id IS NOT NULL AND tt.term_id IS NOT NULL AND l.country_slug LIKE 'colombia' GROUP BY CONCAT(tt.term_id, '-', l.country_slug, '-', l.region_slug) ORDER BY date_gmt DESC

    PD:Please don’t suggest cache queries in the database, it is not possible in my case.

    Thanks!!

    #516912

    Alex Rollin
    Moderator
    Post count: 27815

    Hello,

    we have an option to exclude location pages from the sitemap, you can try that

    GD – Settings – Locations (tab) – Show advanced

    If you need more help we will need to check the settings. Please share WP Admin and FTP credentials in a private reply so we can take a look.

Viewing 2 posts - 1 through 2 (of 2 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount