关于一个减慢我的WordPress网站的查询

Question

I have a site with 100k+ posts and I am trying to use this query:

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') ORDER BY wp_posts.post_date DESC LIMIT 0, 5

After searching for quite some time now, I came to understand that it's a pagination query. The query takes too much time and is not efficient.

Does anyone know of a solution for this problem?

P.S. I have already searched the old answers but they do not provide any solution.

Answer 1

Yes, SQL_CALC_FOUND_ROWS takes more time than two queries. Please check this link:

Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM table, or SELECT COUNT(*)

Lot of users or developers have confirmed, you can read comments of users.

Try to use SELECT COUNT(*) statement to find number of records.