{"id":4477933,"date":"2014-01-07T08:54:39","date_gmt":"2014-01-07T08:54:39","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/orphaned-options\/"},"modified":"2016-08-21T14:29:13","modified_gmt":"2016-08-21T14:29:13","slug":"orphaned-options","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/orphaned-options\/","title":{"rendered":"Orphaned Options"},"content":{"rendered":"<p>Hi,<\/p>\n<p>I have used this plugin on 2 sites and like it very much.<\/p>\n<p>However their is a bug in it. It leaves too many Orphaned Options<br \/>\nI had installed it on a fresh WP site and loaded 150 products (books) amazon. It works fine.<\/p>\n<p>However after running Clean Options plugin ( https:\/\/wordpress.org\/plugins\/clean-options\/ ) i discovered that there are nearly 1200 orphan options like<\/p>\n<p>_transient_wc_average_rating_5720<br \/>\n_transient_wc_rating_count_5775<br \/>\n_transient_wc_uf_pid_1fd348d5ed5a4986c3be103cc2f6df85<br \/>\n_wc_session_1aweHqVud7hqNsNCTBWcfp9aHCwkhAOY<br \/>\n_wc_session_expires_e0EENjD6IzwmjuyMbIfiZSFRGW25up2m<\/p>\n<p>Majority of them are session and session expires.<\/p>\n<p>Since they are all orphan it seems there are no use for them and they unnecessarily bloat the mysql tables<\/p>\n<p>Please look.<\/p>\n<p>https:\/\/wordpress.org\/plugins\/prosociate-amazon\/<\/p>\n","protected":false},"template":"","class_list":["post-4477933","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4477933","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\/4477933\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=4477933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}