vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Performance Hacks... Please advise (https://vborg.vbsupport.ru/showthread.php?t=44267)

Pezman 10-03-2002 11:52 PM

Performance Hacks... Please advise
 
I run a huge vB site. We currently have 2,300 users online at this very second. 80,000 members are registered there.

Our board has no hacks installed. I have found it nearly takes a supercomputer to get the forums working at this level.

I was wondering if someone could direct me to any speed enhancements that are reliable and very stable.

I have kept from installing hacks to this point because it makes it hard to upgrade, and might open ourselves up to security exploits.

Could someone offer any ways to speed up our board? We have had to turn off ForumJump, and WhoIs Online as of late because our numbers are growing so rapidly. Jelsoft seems to be very busy with vB 3.0 and hasn't offered a great deal of help. To my knowledge we are the largest board out there, and would love to grow, but we are reading the limitations of vB at this point.

Specifically I heard of a hack that logs thread views to a temp table then dumps them to the primary database at random times. This would reduce the ammount of time MySQL is locked and allow more users to browse the board. I searched but found nothing, could someone point me to this specific hack?

dabean 10-04-2002 01:28 AM

<a href="https://vborg.vbsupport.ru/showthread.php?s=&threadid=40137&highlight=deferre d+threadviews" target="_blank">https://vborg.vbsupport.ru/showt...ed+threadviews</a>

You should be aware it is still technically a beta hack.
Whilst I have installed it on my forums, I certainly would consider it a last resort solution after exhusting methods of optimising mysql.

Xenon 10-04-2002 08:55 AM

every hack which reduces queries would help you a bit ;)

this for example is a musthave:
https://vborg.vbsupport.ru/showthrea...hlight=queries

Scott MacVicar 10-04-2002 02:49 PM

That is not an improvement btw.

It will actually make things worse as its dependant on the size of your tables.

And please please please realise that number of queries is not everything, its the cost of the query including read / write access to the files and the number of rows that have to be scanned.

For example
SELECT * FROM poll LEFT JOIN thread ON (poll.pollid=thread.pollid) ORDER BY dateline DESC LIMIT 1

is more costly than two seperate queries
SELECT MAX(pollid) as PID FROM thread;
SELECT * FROM poll WHERE poll.pollid=$var[PID]

Also consider posting on the Server Config forum on vBulletin.com and getting eva2000 to optimize your apache and mysql settings.

Are you running two seperate servers? If not then thats the way to go because you have alot of users online.

Scott MacVicar 10-04-2002 02:56 PM

I remember now it doesnt use the index if you do that which causes speed problems :D

Freddie Bingham 10-04-2002 04:17 PM

Either query is terrible unless you put an index on pollid in the thread table.


All times are GMT. The time now is 01:37 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.01052 seconds
  • Memory Usage 1,719KB
  • 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)post_thanks_navbar_search
  • (1)printthread
  • (6)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete