AMP DB queries taking too much time to load

  • AMP DB queries are taking too much time to process. How do we can make it faster
    The below query is taking 10sec to process.

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE ?=? AND wp_posts.ID NOT IN (?) AND (
    wp_term_relationships.term_taxonomy_id IN (?,?,?)
    ) AND (
    ( wp_postmeta.meta_key = ? AND wp_postmeta.meta_value = ? )
    ) AND wp_posts.post_password = ? AND wp_posts.post_type = ? AND ((wp_posts.post_status = ?)) GROUP BY wp_posts.ID ORDER BY wp_posts.ID DESC LIMIT ?, ?

    See the places this query is calling.

    …elerated-mobile-pages/includes/vendor/amp/includes/class-amp-post-template.php (480)
    …elerated-mobile-pages/includes/vendor/amp/includes/class-amp-post-template.php (163)
    …/plugins/accelerated-mobile-pages/templates/design-manager/design-1/single.php (27)
    …elerated-mobile-pages/includes/vendor/amp/includes/class-amp-post-template.php (480)
    …elerated-mobile-pages/includes/vendor/amp/includes/class-amp-post-template.php (163)
    …elerated-mobile-pages/includes/vendor/amp/includes/class-amp-post-template.php (157)
    …/exams/wp-content/plugins/accelerated-mobile-pages/includes/vendor/amp/amp.php (91)
    …PVendor\amp_render called at /var/www/html/exams/wp-includes/in AMPforWP\AMPVendor\amp_render called at /var/www/html/exams/wp-includes/class-wp-hook.php

    How do we can reduce the execution time?

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘AMP DB queries taking too much time to load’ is closed to new replies.