Hello, I run a very busy website and I want to disable post_views_count completely to optimize mysql speed.
I have SHOW POST VIEWS disabled in the theme Post Setting options, but I still see queries running wioth it.
Can it be entirely disabled?
I am getting slow timers from MYSQL:
[Wed Feb 20 19:00:56 2019] [hphp] [13524:7fb8dcfff700:26:000001] [] SlowTimer [1343ms] at runtime/ext_mysql: slow query: SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( \n wp_postmeta.meta_key = ‘post_views_count’\n) AND wp_posts.post_type = ‘post’ AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC LIMIT 0, 3
[Wed Feb 20 19:00:57 2019] [hphp] [13524:7fb8e97ff700:25:000001] [] SlowTimer [1495ms] at runtime/ext_mysql: slow query: SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( \n wp_postmeta.meta_key = ‘post_views_count‘\n) AND wp_posts.post_type = ‘post’ AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC LIMIT 0, 3
[Wed Feb 20 19:00:57 2019] [hphp] [13524:7fb9043ff700:18:000001] [] SlowTimer [1499ms] at runtime/ext_mysql: slow query: SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( \n wp_postmeta.meta_key = ‘post_views_count‘\n) AND wp_posts.post_type = ‘post’ AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC LIMIT 0, 3
Hi,
Please desirable the view count and and comment count from Newspaper>Theme panel>Post settings>Post and Custom Post Type -> https://www.screencast.com/t/l3ZSllC89f8
After that clear all cache and those will be hide for posts.
If you are using default post templates you can comment/remove the code for view count, for example if you have post style 1 -> https://www.screencast.com/t/NPbmTDT6WqY
Thank you!
