• Resolved jeywalk

    (@jeywalk)


    Hi there,

    I use WPEngine to host my wordpress site and use Related Post By Zemanta.

    I am getting the error messages complaining about Long Queries:

    Example:

    [error] [client 198.71.117.152] LONG QUERY: LONG QUERY: \n\t\tSELECT\n\t\t\ttarget.post_id, sum(target.weight * log(361 / least(361, freqs.freq))) as score\n\t\tFROM\n\t\t\twp_zem_rp_tags as target,\n\t\t\t(SELECT label, count(1) as freq FROM wp_zem_rp_tags\n\t\t\t\tWHERE label IN (‘P_camping table’, ‘P_functional design’, ‘P_innovative design’, ‘P_kitchen table’, ‘P_table’, ‘P_well-made’, ‘C_ippinka blog’, ‘C_product stories’, ‘A_tabl’, ‘A_melamin’, ‘A_kitchen’, ‘A_coleman’, ‘A_shelf’, ‘A_steel’, ‘A_lantern’, ‘A_aluminum’, ‘A_portabl’, ‘A_compact’, ‘A_outdoor’, ‘A_foldabl’, ‘A_frame’, ‘A_burner’, ‘A_hanger’)\n\t\t\t\tGROUP BY label\n\t\t\t) as freqs\n\t\tWHERE\n\t\t\ttarget.post_id NOT IN (‘3774’) AND\n\t\t\ttarget.post_date > DATE_SUB(CURDATE(), INTERVAL ‘365’ DAY) AND\n\t\t\ttarget.label=freqs.label AND\n\t\t\ttarget.label IN (‘P_camping table’, ‘P_functional design’, ‘P_innovative design’, ‘P_kitchen table’, ‘P_table’, ‘P_well-made’, ‘C_ippinka blog’, ‘C_product stories’, ‘A_tabl’, ‘A_melamin’, ‘A_kitchen’, ‘A_coleman’, ‘A_shelf’, ‘A_steel’, ‘A_lantern’, ‘A_aluminum’, ‘A_portabl’, ‘A_compact’, ‘A_outdoor’, ‘A_foldabl’, ‘A_frame’, ‘A_burner’, ‘A_hanger’)\n\t\tGROUP BY target.post_id\n\t\tORDER BY score desc, target.post_id desc\n\t\tLIMIT 16;

    —-

    Could you advise what this means and how we can fix this?

    https://www.ads-software.com/plugins/related-posts-by-zemanta/

Viewing 1 replies (of 1 total)
  • Hey,

    thanks for reaching out.

    According to WPEngine’s documentation is just a notice to you that the query exceeds 1024 characters and that it might be optimized, so there’s nothing to worry about.
    This particular query returns related posts – posts with similar calculated tags (e.g. A_kitchen, A_tabl,…) for particular post and can’t be optimized without completely changing the way this plugin works.

    Hope this helps.

    Take care & have a nice day,
    Mateja

Viewing 1 replies (of 1 total)
  • The topic ‘Long Query Error’ is closed to new replies.