vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   improved dot icons - decreases DB load (https://vborg.vbsupport.ru/showthread.php?t=48436)

pwr_sneak 02-01-2003 10:00 PM

improved dot icons - decreases DB load
 
This Hack will decrease the Load on your DB-Server.
It adds one small Query to forumdisplay.php and modifies one big, slow query.
If you have lots of posts and $showdots enabled, this is a must.
If you disabled $showdots via Admin-CP because of performance issues, you can savely enable it now :)

Note: this will NOT work with PHP 3.x or lower

UPDATE: I've added instructions to modifiy member2.php, usercp.php and search.php

ScottRoberts 02-02-2003 12:04 PM

Quote:

Originally posted by pwr_sneak

Note: this will NOT work with PHP 3.x or lower

Or lower? Means it will not work at all...or should this be higher?

pwr_sneak 02-02-2003 12:10 PM

means it will just work with PHP 4 or higher.

Xenon 02-02-2003 12:14 PM

hey, looks very good pwr_sneak.
Joining thread and post table is really a bad thing, so cut them out this way looks good.

Have you some testresults to see the time the two queries take instead of just the one before (just intrested in..)

pwr_sneak 02-02-2003 12:25 PM

Quote:

Originally posted by Xenon
Have you some testresults to see the time the two queries take instead of just the one before (just intrested in..)
the one before showed up often in my slowqueries.log and took much longer than 10 seconds sometimes.
the two new queries takes 13 millisecondes :p

nuno 02-02-2003 12:45 PM

Are you sure it's faster?
I tested this locally and it doesn't seem to be any faster. :confused:

pwr_sneak 02-02-2003 01:05 PM

if you test it with small post and thread tables it wouldn't make a huge difference, but the original code doesn't scale very well.
my forum got 1.4 million posts and 47k threads and it definitely is MUCH faster

nuno 02-02-2003 01:09 PM

OK, i'll upload the new forumdisplay to live forums and let you know how it goes then.
Back in a mo.

nuno 02-02-2003 01:27 PM

I see some improvement finally, it went from 0.095 to 0.090. :)

Chris M 02-02-2003 02:31 PM

Nice:)

Satan


All times are GMT. The time now is 12:34 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.01061 seconds
  • Memory Usage 1,728KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)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