slow query

Resolved

(@mehargd)

Dear,

kindly tellhowtodisable this query..it making wordpress admin slow

SELECT post_status, COUNT( * ) AS num_posts
FROM wp_2_posts
WHERE post_type = ‘product’
GROUP BY post_status

wp_count_posts
WC_Install::is_new_install
WC_Admin_Notices::init
include_once('/plugins/woocommerce/includes/admin/class-wc-admin-notices.php')
WC_Admin->includes
WP_Hook->apply_filters
WP_Hook->do_action
do_action('init')
require_once('wp-settings.php')
require_once('wp-config.php')
require_once('wp-load.php')
require_once('wp-admin/admin.php')

Viewing 4 replies - 1 through 4 (of 4 total)

Plugin Support con
(@conschneider)

Engineer

2 years, 1 month ago

Hi there,

SELECT post_status, COUNT( * ) AS num_posts
FROM wp_2_posts
WHERE post_type = ‘product’
GROUP BY post_status

I did not author the query so I can’t say how it came to be. Would you like to make a suggestion for a better query?
Or are you looking for a way to make your site load faster?

Kind regards,
Thread Starter mehargd
(@mehargd)

2 years, 1 month ago
i am making a way to load site much faster.. our application not at allopens we have more then 1 laks products.. in query monitor i found the above query taking high time and it calls on every page load.
```
wp_count_posts
WC_Install::is_new_install
WC_Admin_Notices::init
include_once('/plugins/woocommerce/includes/admin/class-wc-admin-notices.php')
WC_Admin->includes
WP_Hook->apply_filters
WP_Hook->do_action
do_action('init')
require_once('wp-settings.php')
require_once('wp-config.php')
require_once('wp-load.php')
require_once('wp-admin/admin.php')
```
Thread Starter mehargd
(@mehargd)

2 years, 1 month ago

https://stackoverflow.com/questions/69671030/wordpress-woocommerce-remove-wp-count-posts-call-in-wp-admin

kindly check this url also.

Igor H
(@ihereira)

2 years, 1 month ago

Hello,

You can find general tips e.g. increasing the site’s memory to help your site to run faster, please check:
https://woocommerce.com/document/troubleshooting-a-slow-site/

You can also temporarily deactivate all plugins except WooCommerce, to check if the issue with the slow query persists, if the problem goes away you can then gradually reactivate the plugins one by one to see if you can determine if one of them is the culprit:
https://docs.woocommerce.com/document/how-to-test-for-conflicts/

I hope this helps.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘slow query’ is closed to new replies.