{"id":857,"date":"2024-05-07T11:44:33","date_gmt":"2024-05-07T11:44:33","guid":{"rendered":"https:\/\/kb.shortpixel.com\/docs\/where-exactly-does-shortpixel-store-the-data-on-the-database\/"},"modified":"2025-10-15T14:29:57","modified_gmt":"2025-10-15T14:29:57","password":"","slug":"where-exactly-does-shortpixel-store-the-data-on-the-database","status":"publish","type":"docs","link":"https:\/\/kb.shortpixel.com\/knowledge-base\/article\/where-exactly-does-shortpixel-store-the-data-on-the-database\/","title":{"rendered":"Where exactly does ShortPixel store the data on the database?"},"content":{"rendered":"\n<p>Starting with version 5, ShortPixel Image Optimizer (SPIO) stores necessary information on your WordPress database in the following way:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The tables <code class=\"inline-code\">shortpixel_meta<\/code> and <code class=\"inline-code\">shortpixel_folders<\/code> are created by ShortPixel and they contain your settings for the Custom Media Folders: <a href=\"https:\/\/shortpixel.com\/knowledge-base\/article\/how-to-optimize-images-in-wordpress-themes-and-plugins\/\" rel=\"noopener\">Images outside Media Library<\/a>.<\/li>\n\n\n\n<li>The image optimization data is now stored in the custom table <code class=\"inline-code\">shortpixel_postmeta<\/code>.<\/li>\n\n\n\n<li>The old optimization data (stored in the&nbsp;<code class=\"inline-code\">postmeta<\/code> table) is left untouched, but you have the possibility to remove it by going to Settings &gt; ShortPIxel &gt; Tools &gt; Remove Legacy Data. We do not recommend doing this operation unless you are 100% sure all the data is fully migrated to the new format.<\/li>\n\n\n\n<li>The table&nbsp;<code class=\"inline-code\">shortpixel_queue<\/code> temporarily stores the items that are added to the processing queue, until their processing is finished.<\/li>\n\n\n\n<li>The plugin settings are in the table <code class=\"inline-code\">options<\/code> . All the ShortPixel entries are prefixed with the string <code class=\"inline-code\">spio_settings<\/code> .<\/li>\n\n\n\n<li>It creates an option called <code class=\"inline-code\">shortqwp_spio<\/code>, the queue system our plugin uses to properly process all images in the correct order.<\/li>\n<\/ul>\n\n\n\n<p>Here&#8217;s where <a href=\"https:\/\/wordpress.org\/plugins\/shortpixel-image-optimiser\/\" target=\"_blank\" rel=\"noopener\">ShortPixel Image Optimizer<\/a> (SPIO) used to store all the necessary information on your WordPress database, prior to version 5:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The tables <code class=\"inline-code\">shortpixel_meta<\/code> and <code class=\"inline-code\">shortpixel_folders<\/code> are created by ShortPixel and they contain your settings for the Additional Media Folders: <a href=\"https:\/\/shortpixel.com\/knowledge-base\/article\/how-to-optimize-images-in-wordpress-themes-and-plugins\/\" rel=\"noopener\">Images outside Media Library<\/a>.<\/li>\n\n\n\n<li>The image optimization data is in the table <code class=\"inline-code\">postmeta<\/code>.<\/li>\n\n\n\n<li>The plugin settings are in the table <code class=\"inline-code\">options<\/code> . All the ShortPixel entries are prefixed with the string <code class=\"inline-code\">spio_settings<\/code>.<\/li>\n<\/ul>\n\n\n\n<p><a href=\"https:\/\/wordpress.org\/plugins\/shortpixel-adaptive-images\/\" target=\"_blank\" rel=\"noopener\">ShortPixel Adaptive Images<\/a> stores its settings in the table <code class=\"inline-code\">options<\/code>, just like SPIO, in a single option called&nbsp;<code class=\"inline-code\">short_pixel_ai_options<\/code>.<\/p>\n\n\n\n<p><a href=\"https:\/\/wordpress.org\/plugins\/regenerate-thumbnails-advanced\/\" target=\"_blank\" rel=\"noopener\">Regenerate Thumbnails Advanced<\/a> uses the <code class=\"inline-code\">shortpixel_queue<\/code> table to temporarily store images that are in the process of thumbnail regeneration. It also stores the <code class=\"inline-code\">shortqwp_rta<\/code> option inside the <code class=\"inline-code\">options<\/code> table.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Starting with version 5, ShortPixel Image Optimizer (SPIO) stores necessary information on your WordPress database in the following way: Here&#8217;s where ShortPixel Image Optimizer (SPIO) used to store all the necessary information on your WordPress database, prior to version 5: ShortPixel Adaptive Images stores its settings in the table options, just like SPIO, in a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[35,37],"glossaries":[],"doc_tag":[],"class_list":["post-857","docs","type-docs","status-publish","hentry","doc_category-shortpixel-adaptive-images","doc_category-shortpixel-image-optimizer"],"blocksy_meta":[],"year_month":"2026-04","word_count":299,"total_views":"1128","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"admin","author_nicename":"admin_mdli53m5","author_url":"https:\/\/kb.shortpixel.com\/author\/admin_mdli53m5\/"},"doc_category_info":[{"term_name":"ShortPixel Adaptive Images","term_url":"https:\/\/kb.shortpixel.com\/knowledge-base\/category\/shortpixel-adaptive-images\/"},{"term_name":"ShortPixel Image Optimizer","term_url":"https:\/\/kb.shortpixel.com\/knowledge-base\/category\/shortpixel-image-optimizer\/"}],"doc_tag_info":[],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/kb.shortpixel.com\/wp-json\/wp\/v2\/docs\/857","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.shortpixel.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/kb.shortpixel.com\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/kb.shortpixel.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.shortpixel.com\/wp-json\/wp\/v2\/comments?post=857"}],"version-history":[{"count":3,"href":"https:\/\/kb.shortpixel.com\/wp-json\/wp\/v2\/docs\/857\/revisions"}],"predecessor-version":[{"id":2728,"href":"https:\/\/kb.shortpixel.com\/wp-json\/wp\/v2\/docs\/857\/revisions\/2728"}],"wp:attachment":[{"href":"https:\/\/kb.shortpixel.com\/wp-json\/wp\/v2\/media?parent=857"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/kb.shortpixel.com\/wp-json\/wp\/v2\/doc_category?post=857"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/kb.shortpixel.com\/wp-json\/wp\/v2\/glossaries?post=857"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/kb.shortpixel.com\/wp-json\/wp\/v2\/doc_tag?post=857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}