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 10: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 08:26 AM

Thanks Xenon.. :)

sabret00the 06-30-2004 09:13 AM

nice work stefan :)

FleaBag 06-30-2004 12:42 PM

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

the Sandman 06-30-2004 02:14 PM

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

Dean C 06-30-2004 02:31 PM

Thankyou for sharing your work Stefan :)

Xenon 06-30-2004 03: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 03:36 PM

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

msimplay 06-30-2004 04:10 PM

does it work on version vb3 gold ?

Xenon 06-30-2004 04:17 PM

i think so yes :)


All times are GMT. The time now is 11:21 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.01002 seconds
  • Memory Usage 1,727KB
  • 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