{"id":3311019,"date":"2012-12-28T08:36:20","date_gmt":"2012-12-28T08:36:20","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/speed-up\/"},"modified":"2016-08-20T19:33:51","modified_gmt":"2016-08-20T19:33:51","slug":"speed-up","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/speed-up\/","title":{"rendered":"Speed up"},"content":{"rendered":"<p>Hi, i am using vote it up and if i use the MostVotedAllTime() function the site will be slow.<\/p>\n<p>To speed it up (inspired by http:\/\/www.sitepoint.com\/create-a-voting-plugin-for-wordpress\/) i save the count value in the metas.<\/p>\n<p>votingfunctions.php (only a part)<br \/>\nhttp:\/\/pastebin.com\/1dkbKpSd<\/p>\n<p>To get the value i stop using GetVotes($postID) and start using <\/p>\n<p>$votes = get_post_meta($postID, &#8216;_votemecount&#8217;, true) != &#8221; ? get_post_meta($postID, &#8216;_votemecount&#8217;, true) : &#8216;0&#8217;;<\/p>\n<p>To delete votings i modified the ResetVote Function<\/p>\n<p>http:\/\/pastebin.com\/Smyx61hz<\/p>\n<p>Additionaly i don&#8217;t need guest votings and delete all SQL Statements about that<\/p>\n<p>I use it on http:\/\/www.gwinnr.de and reduce the cpu load about 90% and save 300 querries on some pages<\/p>\n<p>https:\/\/wordpress.org\/extend\/plugins\/vote-it-up\/<\/p>\n","protected":false},"template":"","class_list":["post-3311019","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/3311019","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\/3311019\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=3311019"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}