{"id":19004836,"date":"2026-08-27T17:23:04","date_gmt":"2026-08-27T17:23:04","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/database-queries-and-archive-questions\/"},"modified":"2026-08-27T17:23:04","modified_gmt":"2026-08-27T17:23:04","slug":"database-queries-and-archive-questions","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-queries-and-archive-questions\/","title":{"rendered":"Database Queries and Archive Questions"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Thank you for the work you do to keep SlimStat going!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">On high resource server, the site is constantly having issues related to &#8220;a sustained high volume of MySQL queries&#8221; as the host puts it. They point to repeated requests from SlimStat and unusually long processing times. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the database, the size of wp_slim_stats_archive is 5.3\u00a0GiB with ~9,335,824 rows.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Would the archive table be related to long process times? Are the archives actually used by the plugin once entries are archived, or should the contents of this table be deleted?<\/p>\n","protected":false},"template":"","class_list":["post-19004836","topic","type-topic","status-publish","hentry","topic-tag-database","topic-tag-mysql"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/19004836","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":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/19004836\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=19004836"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}