WordPress search functionality works by querying the WordPress database to retrieve posts and pages that match the search query entered by the user.WordPress stores content such as posts, pages, comments, and other information in its database. The primary tables relevant to search include wp_posts, which contains post data, and wp_postmeta, which contains metadata associated with posts.WordPress constructs a SQL query based on the processed search query. By default, WordPress searches for matches in the post title, post content, and post excerpt fields of the wp_posts table. It may also search in other fields depending on configuration and plugins.
For Limit search You just need to use the code in your theme functions.php
function search_only_titles( $search, $wp_query ) {
global $wpdb;
if ( ! empty( $search ) && ! is_admin() && $wp_query->is_search ) {
$search = " AND {$wpdb->posts}.post_title LIKE '%" . esc_sql( get_query_var( 's' ) ) . "%'";
}
return $search;
}
add_filter( 'posts_search', 'search_only_titles', 10, 2 );
How high CPU usage by search Full site:
WordPress post search typically doesn’t inherently use a high amount of CPU unless there are specific issues or circumstances causing it to do so. Here are some potential reasons why WordPress post search might be causing high CPU usage:
- Large Number of Posts: If your WordPress site has a large number of posts, searching through them can put a strain on server resources, especially if the search queries are complex or not optimized.
- Unoptimized Database Queries: WordPress search functionality relies on database queries to retrieve search results. If these queries are not optimized or if there are inefficient database indexes, it can lead to high CPU usage, especially on sites with large databases.
- Complex Search Queries: If users are performing complex search queries that involve multiple search parameters or complex filters, it can increase the CPU usage required to process those queries.
- Inefficient Plugins or Themes: Certain plugins or themes may introduce inefficient code that negatively impacts the performance of the search functionality. This could include plugins that modify or extend the default search behavior in WordPress.
- Insufficient Server Resources: If your server doesn’t have enough resources (CPU, memory, etc.) to handle the search queries efficiently, it can lead to high CPU usage during peak usage periods.
- Search Indexing: WordPress by default doesn’t have advanced search indexing capabilities. If you’re using a plugin to add search indexing (such as Elasticsearch), the indexing process itself can consume CPU resources, especially if it’s running frequently or on large datasets.
- Bot Traffic: If your site experiences a lot of bot traffic, particularly from search engine crawlers, it can increase the load on your server as they index your site’s content.
To address high CPU usage related to WordPress post search, consider the following steps:
- Optimize your WordPress database by cleaning up unnecessary data, optimizing database tables, and ensuring that indexes are properly configured.
- Install and configure a caching plugin to cache search results and reduce the load on your server.
- Evaluate and potentially deactivate or replace any plugins or themes that are known to cause performance issues.
- Consider upgrading your hosting plan to one with more resources if your current plan is insufficient.
- Implement search indexing solutions like Elasticsearch to improve search performance and reduce server load.
- Monitor your server’s resource usage regularly and investigate any spikes in CPU usage to identify and address the root cause.
By addressing these potential issues and optimizing your WordPress site’s search functionality, you can reduce CPU usage and improve overall performance.