Optmize Show Public Poll Results

[Xenon]

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

[Oblivion Knight]

Thanks Xenon.. :)

[sabret00the]

nice work stefan :)

[FleaBag]

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

[the Sandman]

How does this optimization relate to This Bug Report & Fix (http://www.vbulletin.com/forum/bugs.php?do=view&bugid=3060)?

[Dean C]

Thankyou for sharing your work Stefan :)

[Xenon]

@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.

[Mijae]

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

[msimplay]

does it work on version vb3 gold ?

[Xenon]

i think so yes :)

[msimplay]

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

[Alien]

Nice work here, thanks bunches Xenon! :D

[Oblivion Knight]

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?

[Natch]

<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 ...

[Xenon]

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?
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 :)

[Oblivion Knight]

Alright, thanks for that Stefan.. :)

[theArchitect]

Alright, thanks for that Stefan.. :)
Is it just me or has this been included as standard in 3.0.3?

[Xenon]

yes, this has been included into 3.0.3 :)

[Blam Forumz]

installe don 3,0.2!