WordPress.org
Get WordPress

Make WordPress Core

Changes between Initial Version and Version 2 of Ticket #30416


Ignore:
Timestamp:
11/20/2014 10:05:23 AM (11 years ago)
Author:
SergeyBiryukov
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #30416

    • Property Focuses multisite performance added
    • Property Severity changed from normal to critical

  • Ticket #30416 – Description

    initial v2  
    33It is configured under a dedicated Server and the performance are good except when users use the search function.
    44
    5 We have the same problem resolved in this ticket:
    6 
    7 https://core.trac.wordpress.org/ticket/10964
     5We have the same problem resolved in this ticket: #10964
    86
    97but our WordPress is 4.0 version and the patch file attached isn't useful for us.
    … …  
    119We monitored Db performance with mytop and we found this query very heavy:
    1210
    13 SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND (((wp_posts.post_title LIKE '%festival.\\%20ombre%') OR (wp_posts.post_con...
     11`SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND (((wp_posts.post_title LIKE '%festival.\\%20ombre%') OR (wp_posts.post_con...`
    1412
    1513Can you help us to patch this problem and find the best solution for improving performance?