Speed problem | WordPress.org

Hi,

We have noticed quite a significant impact on speed in admin when displaying either the products list page or the orders list page. This increases the page generation time from around 2s to around 4s and seems to be cuased by the following query:

SELECT p.ID FROM 1e_posts p, 1e_postmeta pm WHERE pm.post_id=p.ID AND p.post_type=s AND p.post_date>=date_sub(now(),interval 1 hour) AND p.post_modified>=date_sub(now(),interval 1 hour) GROUP BY p.ID

Traceback:

do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, wc_slw_admin_init, slw_update_products

This is taking around 2.3s to execute.

We have arounf 10,000 products in 3 stock locations

Is there any way to improve this ?

Regards
Simon Silver

• This topic was modified 4 hours, 9 minutes ago by firepages.