vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Optmize Show Public Poll Results (https://vborg.vbsupport.ru/showthread.php?t=66694)

Xenon 06-29-2004 09:00 PM

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

Oblivion Knight 06-30-2004 07:26 AM

Thanks Xenon.. :)

sabret00the 06-30-2004 08:13 AM

nice work stefan :)

FleaBag 06-30-2004 11:42 AM

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

the Sandman 06-30-2004 01:14 PM

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

Dean C 06-30-2004 01:31 PM

Thankyou for sharing your work Stefan :)

Xenon 06-30-2004 02:02 PM

@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 06-30-2004 02:36 PM

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

msimplay 06-30-2004 03:10 PM

does it work on version vb3 gold ?

Xenon 06-30-2004 03:17 PM

i think so yes :)


All times are GMT. The time now is 08:28 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03057 seconds
  • Memory Usage 1,725KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete