Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Optmize Show Public Poll Results Details »
Optmize Show Public Poll Results
Mod Version: 1.00, by Xenon (Member) Xenon is offline
Developer Last Online: Jul 2018 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.0.1 Rating: (2 votes - 5.00 average) Installs: 11
Released: 30 Jun 2004 Last Update: Never Downloads: 9
Not Supported DB Changes  

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: http://www.vbulletin.org/forum/showthread.php?t=66689

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Show poll results in descending order Andreas vBulletin 3.0 Full Releases 24 29 Oct 2007 23:17

Comments
  #2  
Old 30 Jun 2004, 10:26
Oblivion Knight's Avatar
Oblivion Knight Oblivion Knight is offline
 
Join Date: May 2002
Real name: Andy
Thanks Xenon..
Reply With Quote
  #3  
Old 30 Jun 2004, 11:13
sabret00the's Avatar
sabret00the sabret00the is offline
 
Join Date: Jan 2003
Real name: sabe
nice work stefan
__________________
UNDER CONSTRUCTION: Confessionary Hack

Make me a Hack of The Month author: GRPS: Groups Commune
make my hacks, they'll make you famous

unless it's a security concern, please do not pm/im me for support unless you're willing to pay.
Reply With Quote
  #4  
Old 30 Jun 2004, 14:42
FleaBag's Avatar
FleaBag FleaBag is offline
 
Join Date: Dec 2001
Cool I'm always up for an optimization.
Reply With Quote
  #5  
Old 30 Jun 2004, 16:14
the Sandman's Avatar
the Sandman the Sandman is offline
 
Join Date: Aug 2003
How does this optimization relate to This Bug Report & Fix?
__________________
The Admin Zone Forums Discussions & Articles for Forum Administrators

Interviews: Kier Scott Jerry Mike Sullivan Andreas Steve Machol Wayne Luke Jake Bunce Floris Logician Xenon Erwin Brad
Reply With Quote
  #6  
Old 30 Jun 2004, 16:31
Dean C's Avatar
Dean C Dean C is offline
 
Join Date: Jan 2002
Real name: Dean Clatworthy
Thankyou for sharing your work Stefan
__________________
Dean Clatworthy - Web Developer/Designer
Reply With Quote
  #7  
Old 30 Jun 2004, 17:02
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
@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.
Reply With Quote
  #8  
Old 30 Jun 2004, 17:36
Mijae's Avatar
Mijae Mijae is offline
 
Join Date: Nov 2001
I have a small board but I installed this anyways
Reply With Quote
  #9  
Old 30 Jun 2004, 18:10
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
does it work on version vb3 gold ?
Reply With Quote
  #10  
Old 30 Jun 2004, 18:17
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
i think so yes
Reply With Quote
  #11  
Old 30 Jun 2004, 18:22
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
confirmed to work hehe just installed ps thanks for a fast reply
Reply With Quote
  #12  
Old 01 Jul 2004, 05:07
Alien's Avatar
Alien Alien is offline
 
Join Date: Oct 2001
Nice work here, thanks bunches Xenon!
__________________
-Jason / WTF!?
Reply With Quote
  #13  
Old 04 Jul 2004, 18:48
Oblivion Knight's Avatar
Oblivion Knight Oblivion Knight is offline
 
Join Date: May 2002
Real name: Andy
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?
Reply With Quote
  #14  
Old 04 Jul 2004, 18:58
Natch's Avatar
Natch Natch is offline
 
Join Date: Nov 2002
Important for those users who have installed this hack - you will encounter errors when running the upgrade script ...
__________________
Natcher00
... is the Admin @ MobileForces.org - Official Community for a cult Vehicle based FPS - the only place for support!
... also he's Penfold to Dark_Wizard's Danger Mouse in development of vBWar
http://www.mobileforces.org/sig.jpg
{DaniWeb: Learn HOW-TO mod_rewrite your vB board}
Reply With Quote
  #15  
Old 05 Jul 2004, 19:08
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
Originally Posted by 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?
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
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 23:31.

Layout Options | Width: Wide Color: