https://legacy.forums.gravityhelp.com/topic/popular-polls-load-on-server Gravity Support Forums Topic: popular polls load on server en-US Mon, 20 Apr 2026 05:19:02 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/popular-polls-load-on-server#post-376166 Sun, 28 Jul 2013 09:37:28 +0000 Richard Vav 376166@https://legacy.forums.gravityhelp.com/ <p>If you still require assistance with this please open a new <a href="http://www.gravityhelp.com/request-support/" rel="nofollow">support ticket</a> or a <a href="http://www.gravityhelp.com/priority-support/" rel="nofollow">priority support ticket</a> if you are a developer license holder. Thank you. </p> https://legacy.forums.gravityhelp.com/topic/popular-polls-load-on-server#post-341981 Mon, 24 Jun 2013 08:49:49 +0000 driveroll 341981@https://legacy.forums.gravityhelp.com/ <p>Indeed, seems we're talking about the same issue here: <a href="http://www.gravityhelp.com/forums/topic/poll-results-different-on-front-end-than-from-back-end?replies=1#post-340278" rel="nofollow">http://www.gravityhelp.com/forums/topic/poll-results-different-on-front-end-than-from-back-end?replies=1#post-340278</a></p> <p>Another thing to note is that we've noticed a strange behavior, that seems beyond using cache, because we've documented the results being smaller than those shown on backend, then at some point they got almost accurate when they went up, and then again we've seen them go back down. I've tried and tried to figure this out but I'm out of clues.</p> <p>Please respond to this ASAP </p> https://legacy.forums.gravityhelp.com/topic/popular-polls-load-on-server#post-304428 Wed, 05 Jun 2013 19:53:05 +0000 dmitryb 304428@https://legacy.forums.gravityhelp.com/ <p>I wouldn't mind the cached results being delayed, if they were accurate. But it seems only partial results are generated:</p> <p><a href="http://www.canadianfamily.ca/contests/teacher-awards-current-results/" rel="nofollow">http://www.canadianfamily.ca/contests/teacher-awards-current-results/</a></p> <p>for example, Sue is showing 624 votes, but in the back-end, it shows she has 2238 votes. Similar with another 'popular' candidate - Sharon is showing 773 votes in front-end, but the back-end stats have her receive over 3800 votes.</p> <p>Is it possible that results are pulled out partially because database queries time out? Is there a way to fix it?</p> <p>Thanks in advance for your suggestions. </p> https://legacy.forums.gravityhelp.com/topic/popular-polls-load-on-server#post-304233 Wed, 05 Jun 2013 15:44:49 +0000 Alex Cancado 304233@https://legacy.forums.gravityhelp.com/ <p>Ok, so you do have a lot of entries and is running the latest version of the Polls Add-On which does use caching, so the delays you see are normal. I would imagine that the delay for 20k would be many hours. Given the complexity of building the cache, there isn't anything that we can do to make it any faster, so unfortunately this is a limitation we currently have. </p> https://legacy.forums.gravityhelp.com/topic/popular-polls-load-on-server#post-304029 Wed, 05 Jun 2013 13:32:50 +0000 dmitryb 304029@https://legacy.forums.gravityhelp.com/ <p>we have over 20k entries, and are running 1.4.5 version of polls. The 'results' page still keeps fluctuating:</p> <p><a href="http://www.canadianfamily.ca/contests/teacher-awards-current-results/" rel="nofollow">http://www.canadianfamily.ca/contests/teacher-awards-current-results/</a> </p> https://legacy.forums.gravityhelp.com/topic/popular-polls-load-on-server#post-293151 Fri, 31 May 2013 16:25:01 +0000 Alex Cancado 293151@https://legacy.forums.gravityhelp.com/ <p>The Polls Add-On does use caching, so there will be a delay. On forms with thousands of entries, the delay could be long (12 hours or so). How many entries do you have, and which version of the Polls Add-On are you running? </p> https://legacy.forums.gravityhelp.com/topic/popular-polls-load-on-server#post-292654 Fri, 31 May 2013 11:04:54 +0000 dmitryb 292654@https://legacy.forums.gravityhelp.com/ <p>Hmm, the results page definitely loads faster, but it's not showing all the stats:</p> <p><a href="http://www.canadianfamily.ca/contests/teacher-awards-current-results/" rel="nofollow">http://www.canadianfamily.ca/contests/teacher-awards-current-results/</a></p> <p>each candidate (in the back-end) is showing significantly more votes. Is this a cache issue, or totals are not calculated correctly? Please advise... </p> https://legacy.forums.gravityhelp.com/topic/popular-polls-load-on-server#post-290167 Thu, 30 May 2013 15:32:39 +0000 David Peralty 290167@https://legacy.forums.gravityhelp.com/ <p>Sent you a new version of the Polls add-on. Give it a try. </p> https://legacy.forums.gravityhelp.com/topic/popular-polls-load-on-server#post-284013 Tue, 28 May 2013 15:05:42 +0000 David Peralty 284013@https://legacy.forums.gravityhelp.com/ <p>I sent a note to the development team. </p> https://legacy.forums.gravityhelp.com/topic/popular-polls-load-on-server#post-283961 Tue, 28 May 2013 14:38:35 +0000 dmitryb 283961@https://legacy.forums.gravityhelp.com/ <p>We have a pretty popular poll/vote contest running using this plugin. However, we're seeing a lot of records pulled from database with this call:</p> <p>SELECT filtered.sort, l.*, d.field_number, d.value<br /> FROM wp_rg_lead l<br /> INNER JOIN wp_rg_lead_detail d ON d.lead_id = l.id<br /> INNER JOIN<br /> ( SELECT @rownum:=@rownum + 1 as sort, id<br /> FROM<br /> ( SELECT distinct l.id<br /> FROM wp_rg_lead l<br /> INNER JOIN wp_rg_lead_detail d ON d.lead_id = l.id<br /> WHERE l.form_id=11<br /> AND status='active'<br /> ORDER BY date_created DESC<br /> LIMIT 2200,100<br /> ) page<br /> ) filtered ON filtered.id = l.id<br /> ORDER BY filtered.sort </p> <p>Is this by design? Seems like a lot of extra data being pulled out. Is there a way to optimize this call? here's the live contest:<br /> <a href="http://www.canadianfamily.ca/contests/teacher-awards-voting-phase/" rel="nofollow">http://www.canadianfamily.ca/contests/teacher-awards-voting-phase/</a></p> <p>Thanks </p>