{"id":17955053,"date":"2024-08-15T13:31:53","date_gmt":"2024-08-15T13:31:53","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/high-load-avarage-and-slow-admin-panel\/"},"modified":"2024-08-15T13:44:07","modified_gmt":"2024-08-15T13:44:07","slug":"high-load-avarage-and-slow-admin-panel","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/high-load-avarage-and-slow-admin-panel\/","title":{"rendered":"high load avarage and slow admin panel"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Hello, <br \/><br \/>I use the Woodmart theme on my website. (tested with Storefront theme and the result is the same) I have over 400k products and there was a clone of my website that I used smoothly when I had 100k products in the test environment. I have a powerful 32 core system<br \/><br \/>and only 2 websites are hosted on this server. load avarages vary from 25-28. When I check my queries with the Query Monitor plugin, it finds woocommerce as responsible. <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT SQL_CALC_FOUND_ROWS 8MIzDi_posts.ID<br \/>FROM 8MIzDi_posts<br \/>LEFT JOIN 8MIzDi_postmeta<br \/>ON ( 8MIzDi_posts.ID = 8MIzDi_postmeta.post_id<br \/>AND 8MIzDi_postmeta.meta_key = '_headstart_post' )<br \/>LEFT JOIN 8MIzDi_postmeta AS mt1<br \/>ON ( 8MIzDi_posts.ID = mt1.post_id )<br \/>WHERE 1=1<br \/>AND ( 8MIzDi_postmeta.post_id IS NULL<br \/>OR mt1.meta_key = '_edit_last' )<br \/>AND 8MIzDi_posts.post_type = 'product'<br \/>AND ((8MIzDi_posts.post_status = 'publish'))<br \/>GROUP BY 8MIzDi_posts.ID<br \/>ORDER BY 8MIzDi_posts.post_date DESC<br \/>LIMIT\u00a00,\u00a010<\/code><\/pre>\n","protected":false},"template":"","class_list":["post-17955053","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17955053","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17955053\/revisions"}],"predecessor-version":[{"id":17955078,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17955053\/revisions\/17955078"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=17955053"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}