Hi, I found this type of calls in mysql.
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts
I read that it may have to do with the pagination. Is there a way to disable the pagination to confirm this situation?
What options do I have to prevent my server from collapsing due to the excessive use of these calls?
Thanks for your help
Hi,
I believe you are referring to the pagination present on the bottom of the page, in the latest articles section. You would have to disable this section in order to remove the pagination. This can be done by selecting a different page template, in the page settings
– https://www.screencast.com/t/T3Ubtm4NrO
Please note that also block pagination can have an impact in this matter. You can try to reduce the number of blocks that use pagination for example
– https://www.screencast.com/t/p9s2r4zpo6z
Thanks
Thanks for your response… to be sure.. can you confirm me if this kind of queries have to be with the pagination ??
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID F
ROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( \n wp_term_relationshi
ps.term_taxonomy_id IN (6)\n) AND wp_posts.post_type = ‘post’ AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.ID ORDER BY wp_p
osts.post_date DESC LIMIT 0, 5
If so, is there a way to override the Categories pagination too ?
Thanks
Hi,
It could be related to pagination. I found this topic
– https://wpartisan.me/tutorials/wordpress-database-queries-speed-sql_calc_found_rows
Category pagination can be modified for each category or in general, but not disabled
– https://forum.tagdiv.com/how-category-settings-work/
The theme requirements are mentioned here for the best results
– https://forum.tagdiv.com/requirements-for-newspaper/
Also check these server and WordPress parameters seen in the theme system status
– https://forum.tagdiv.com/system-status-parameters-guide/
Thanks
Thanks.. great support.
