Posts taking up to 30 seconds to load

  • Hi,

    About two days ago my posts started to take a long time to load. They were working
    fine before that and there have been no changes made. I’ve run debug, used testing sites, checked the bandwidth at the server – it’s on an Azure VM -I can’t find the cause.

    I’ve been having issues with the admin dashboard – it takes about 2 minutes, literally, to add a new post or page and many other options take as long to open/edit – but many seem to be having that issue and the front-end was always working very fast.

    If anybody can take a look or point me in the right direction I’d very much appreciate it!
    Rob

Viewing 4 replies - 16 through 19 (of 19 total)
  • Thread Starter Robert

    (@robg48)

    No problem!

    This one was a bit quicker loading – 10 seconds – but here are the same two sections:

    <!-- [ACTION] it_get_template_part: 1.2083511352539-->

        <!-- [ACTION] it_get_template_part: 1.2171471118927-->

<!-- [ACTION] it_get_template_part: 1.2246840000153-->

<!-- [ACTION] it_before_content_page: 1.2384819984436-->
<!-- [ACTION] update_post_meta: 1.2400209903717-->
<!-- [ACTION] update_postmeta: 1.2400341033936-->
<!-- [ACTION] updated_post_meta: 5.1839849948883-->
<!-- [ACTION] updated_postmeta: 5.1840059757233-->
<!-- [update_meta_cache] CHECKPOINT 1: 5.1843340396881-->
<!-- [update_meta_cache] CHECKPOINT 2: 5.1843581199646-->
<!-- [update_meta_cache] CHECKPOINT 3: 5.1856250762939-->
<!-- [update_meta_cache] CHECKPOINT 4: 5.1856479644775-->
<!-- [ACTION] update_post_meta: 5.186723947525-->
<!-- [ACTION] update_postmeta: 5.1867351531982-->
<!-- [ACTION] updated_post_meta: 9.2427611351013-->
<!-- [ACTION] updated_postmeta: 9.2427821159363-->
    <!-- [ACTION] parse_tax_query: 9.2682061195374-->
<!-- [ACTION] parse_tax_query: 9.2725670337677-->
<!-- [ACTION] posts_selection: 9.2736821174622-->
<!-- [update_meta_cache] CHECKPOINT 1: 9.2828559875488-->
<!-- [update_meta_cache] CHECKPOINT 2: 9.2829101085663-->
<!-- [update_meta_cache] CHECKPOINT 3: 9.40989112854-->
<!-- [update_meta_cache] CHECKPOINT 4: 9.4099650382996-->
<!-- [update_meta_cache] CHECKPOINT 1: 9.4110381603241-->
<!-- [update_meta_cache] CHECKPOINT 2: 9.411092042923-->
<!-- [ACTION] parse_tax_query: 9.4113500118256-->
<!-- [ACTION] parse_tax_query: 9.4121279716492-->
<!-- [ACTION] posts_selection: 9.413409948349-->
<!-- [update_meta_cache] CHECKPOINT 1: 9.4166750907898-->
<!-- [update_meta_cache] CHECKPOINT 2: 9.4167079925537-->
<!-- [update_meta_cache] CHECKPOINT 3: 9.4322941303253-->
<!-- [update_meta_cache] CHECKPOINT 4: 9.4323160648346-->
<!-- [update_meta_cache] CHECKPOINT 1: 9.4326369762421-->
<!-- [update_meta_cache] CHECKPOINT 2: 9.4326641559601-->
<!-- [ACTION] parse_tax_query: 9.4340319633484-->
<!-- [ACTION] parse_tax_query: 9.4347970485687-->
<!-- [ACTION] posts_selection: 9.4386420249939-->
<!-- [update_meta_cache] CHECKPOINT 1: 9.4479429721832-->
<!-- [update_meta_cache] CHECKPOINT 2: 9.4479999542236-->
<!-- [update_meta_cache] CHECKPOINT 3: 9.5656800270081-->
<!-- [update_meta_cache] CHECKPOINT 4: 9.5657300949097-->
<!-- [update_meta_cache] CHECKPOINT 1: 9.5666260719299-->
<!-- [update_meta_cache] CHECKPOINT 2: 9.5666711330414-->
<!-- [ACTION] parse_tax_query: 9.5669641494751-->
<!-- [ACTION] parse_tax_query: 9.5676770210266-->
<!-- [ACTION] posts_selection: 9.5699670314789-->
<!-- [update_meta_cache] CHECKPOINT 1: 9.5718200206757-->
<!-- [update_meta_cache] CHECKPOINT 2: 9.5718679428101-->
<!-- [update_meta_cache] CHECKPOINT 1: 9.572014093399-->
<!-- [update_meta_cache] CHECKPOINT 2: 9.5720369815826-->
<!-- [update_meta_cache] CHECKPOINT 3: 9.572909116745-->
<!-- [update_meta_cache] CHECKPOINT 4: 9.5729329586029-->
<!-- [ACTION] parse_tax_query: 9.5741369724274-->
<!-- [ACTION] parse_tax_query: 9.5748071670532-->
<!-- [ACTION] posts_selection: 9.5757949352264-->
<!-- [update_meta_cache] CHECKPOINT 1: 9.5812981128693-->
<!-- [update_meta_cache] CHECKPOINT 2: 9.5813460350037-->
<!-- [ACTION] begin_fetch_post_thumbnail_html: 9.5856759548187-->
<!-- [update_meta_cache] CHECKPOINT 1: 9.5905740261078-->
<!-- [update_meta_cache] CHECKPOINT 2: 9.5906209945679-->
<!-- [update_meta_cache] CHECKPOINT 3: 9.643895149231-->
<!-- [update_meta_cache] CHECKPOINT 4: 9.643942117691-->
<!-- [ACTION] end_fetch_post_thumbnail_html: 9.6454830169678-->
<!-- [ACTION] begin_fetch_post_thumbnail_html: 9.6466290950775-->
<!-- [ACTION] end_fetch_post_thumbnail_html: 9.6481900215149-->
<!-- [ACTION] begin_fetch_post_thumbnail_html: 9.6492221355438-->
<!-- [ACTION] end_fetch_post_thumbnail_html: 9.6506230831146-->
<!-- [ACTION] begin_fetch_post_thumbnail_html: 9.6517651081085-->
<!-- [ACTION] end_fetch_post_thumbnail_html: 9.653167963028-->
<!-- [ACTION] begin_fetch_post_thumbnail_html: 9.6579661369324-->
<!-- [ACTION] end_fetch_post_thumbnail_html: 9.6596059799194-->
<!-- [ACTION] begin_fetch_post_thumbnail_html: 9.6606531143188-->
<!-- [ACTION] end_fetch_post_thumbnail_html: 9.6620531082153-->
    Thread Starter Robert

    (@robg48)

    Hello,
    I may open a new ticket as this seems to be a known issue – but I couldn’t find any solutions that are “new” – all the solutions I could find seem to be from 4-6 years ago and I’m hesitant to try them on 4.2.2.

    But this, below, is what is causing the posts to load slowly. I also found that the admin slowness – 50-100 seconds to “add new page/post” is caused by another know issue – wp_enque_media problem. WP has several tickets open trying to solve that issue.

    But if you have any ideas I’d love to hear them.

    Here is the offender for the slow loading posts – it has to do with this call:

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
INNER JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE 1=1
AND wp_posts.ID NOT IN (248393)
AND ( wp_term_relationships.term_taxonomy_id IN (17035,17036,17037,17038,17039,17040,17041,17042,17043,17044,17045,17046,17047,17048,17049,17050,17051,17052,17053,17054,17055,17056,17057,17058,17059,17060,17061,17062,17063,17064,17065,17066,17067,17095,17096,17097,17098,17099,17100,17101,17102,17103,17104,17105,17106,17107,17108,17109,17110,17111,17112,17113,17114,17115,17116,17117,17118,17142,17143,17144,17145,17146,17147,17148,17149,17150,17151,17152,17153,17154,17155,17156,17157,17158,17159,17160,17164,17165,17168,17169,17170,17171,17172,17173,17174,17175,17176,17177,17178,17179,17180,17181,17182,17183,17184,17185,17186,17187,17188,17189,21061,21062) )
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private')
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 6

    Thank you for all your help and suggestions – it’s what allowed me to get this far!

    Rob

    It’s something specific whenever the update_postmeta event is called. That code I had you put in didn’t execute, make sure you open a page that hasn’t been opened in a while. You’ll see a big block of junk that looks like:

    Array (
  [blahblah] => Array(
    Thread Starter Robert

    (@robg48)

    Good morning,

    Other than “call_user_func_array” this is the only instance of “array”
    in my source after trying several new pages:

    Array
(
    [0] => post
)

Viewing 4 replies - 16 through 19 (of 19 total)
  • The topic ‘Posts taking up to 30 seconds to load’ is closed to new replies.

Tags