Optmize Show Public Poll Results
 

Time for another vb3 optimization, don't you think.

This hack reduces the ammount of queries generated by the show poll result feature, when it's a public poll.
On larger boards with a lot of votes, this can have a very strong effect. find out more here: https://vborg.vbsupport.ru/showthread.php?t=66689

Thanks Xenon.. :)

nice work stefan :)

Cool I'm always up for an optimization. :)

How does this optimization relate to This Bug Report & Fix?

Thankyou for sharing your work Stefan :)

@The Sandman: well, this hack is the solution for the bug report

the nested query isn't fixed in the bugtracker, just the index structure is changed, but that doesn't reduce the ammount of queries.

I have a small board but I installed this anyways :D

does it work on version vb3 gold ?

i think so yes :)

confirmed to work hehe just installed ps thanks for a fast reply

Nice work here, thanks bunches Xenon! :D

I assume Jelsoft have made their own changes to take care of this optimization for 3.0.2?

Or does your file change (poll.php) still apply?

<a href="https://vborg.vbsupport.ru/showthread.php?t=66842&highlight=optimisation" target="_blank">Important for those users who have installed this hack</a> - you will encounter errors when running the upgrade script ...

actually Jelsoft did the same optimizations as i did ;)

so if you've installed vb302 or 303 you won't need that hack anymore, it's just for 301 or lower :)

Alright, thanks for that Stefan.. :)

Is it just me or has this been included as standard in 3.0.3?

yes, this has been included into 3.0.3 :)

installe don 3,0.2!