Support » Plugin: Front End PM » MySQL queries optimization

  • Resolved as517

    (@as517)


    Hi. I use the old version of this plugin (8.4)

    Slow query causes the server to crash.
    Example

    
    # Query_time: 5.251648  Lock_time: 0.000346 Rows_sent: 2  Rows_examined: 199189
    SET timestamp=1595970481;
    SELECT   trade_posts.ID FROM trade_posts  LEFT JOIN trade_postmeta ON ( trade_posts.ID = trade_postmeta.post_id )  LEFT JOIN trade_postmeta AS mt1 ON (trade_posts.ID = mt1.post_id AND mt1.meta_key = '_fep_delete_by_1' )  LEFT JOIN trade_postmeta AS mt2 ON (trade_posts.ID = mt2.post_id AND mt2.meta_key = '_fep_parent_read_by_1' ) WHERE 1=1  AND trade_posts.post_parent = 0  AND ( 
      ( trade_postmeta.meta_key = '_fep_participants' AND trade_postmeta.meta_value = '1' ) 
      AND 
      mt1.post_id IS NULL 
      AND 
      mt2.post_id IS NULL
    ) AND trade_posts.post_type = 'fep_message' AND ((trade_posts.post_status = 'publish')) GROUP BY trade_posts.ID ORDER BY trade_posts.post_date DESC;
    

    What is the solution to this problem?

    Thank you for help.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Shamim Hasan

    (@shamim51)

    I suggest you to update to latest version.
    Latest version can handle far more messages then previous versions.
    NOTE: Backup first before update to latest version.

    Thread Starter as517

    (@as517)

    Is it possible to do something without updates?

    Plugin Author Shamim Hasan

    (@shamim51)

    In that case i am out of idea. It needs a lot to change.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘MySQL queries optimization’ is closed to new replies.