Go Back   vb.org Archive > Community Central > Community Lounge
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #11  
Old 04-19-2004, 12:13 AM
Brad Brad is offline
 
Join Date: Nov 2001
Posts: 4,765
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The number of tables dose not matter much, speed in a database depends more on how tables are laid out and interacting with each other, and what SQL you are writting in the files to talk to the database.
Reply With Quote
  #12  
Old 04-19-2004, 12:16 AM
Velocd's Avatar
Velocd Velocd is offline
 
Join Date: Mar 2002
Location: CA University
Posts: 1,696
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The issue of this thread is not about speed, because vB3 is plenty fast. If it is going slow, maybe it's your server. If you're on a shared server, it could be other sites consuming the bandwidth.

If your site is losing members, it's foolish to put the blame on the forum software. The content/theme, design, style, and/or features of your site might be losing attention.

Work on those areas. vBulletin is an almost flawless software and has the potential to bring out the best of communities. As an administrator, you need to plan how to attain the great community through your vBulletin.
Reply With Quote
  #13  
Old 04-19-2004, 12:29 AM
Dras Dras is offline
 
Join Date: Dec 2002
Posts: 50
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Maybe I am not saying it right. I am saying once you have a connection that's 1 connection ok. Then since you have more tables to grab data from you have to use more query's (I can't spell tonight sorry), which slows the speed down since it has to grab more data from different tables.

But like I said try install PHP 4.3.4 or PHP 4.3.5 and see if it increases you speed. What I did in the past on a linux machine was install Zend optamizer. This usually speeds up the script 40%. Atleast with mine it did. If you own a dedicated server head over to zend.com, if not ask your host to install it since it speeds up PHP files.
Reply With Quote
  #14  
Old 04-19-2004, 12:41 AM
lasto lasto is offline
 
Join Date: Jan 2002
Posts: 1,514
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

tell em u are planning on having a babe section - they will soon come back cause who can resist the temptation of a woman
Reply With Quote
  #15  
Old 04-19-2004, 03:22 AM
SaN-DeeP's Avatar
SaN-DeeP SaN-DeeP is offline
 
Join Date: Jun 2002
Location: Mumbai, India
Posts: 1,195
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Velocd
The issue of this thread is not about speed, because vB3 is plenty fast. If it is going slow, maybe it's your server. If you're on a shared server, it could be other sites consuming the bandwidth.

If your site is losing members, it's foolish to put the blame on the forum software. The content/theme, design, style, and/or features of your site might be losing attention.

Work on those areas. vBulletin is an almost flawless software and has the potential to bring out the best of communities. As an administrator, you need to plan how to attain the great community through your vBulletin.
hi Velocd,
Perfect point.

As you mite have noted from my first 2 posts. what i wrote.
Its not VB3 which is cozing problems for sure. it is the tweaking i need to retain exising people.

About server config/info i have stated above. What i have @ the moment.
Please let me know what else is required.

About the Speeds, I have tested my server bandwiths with few of my members, located worldwide.
A Download speed of 100 KBPS @ each end was acheived continously, from 15 ends simuletaneously.
Tested this speeds, couple of times a week..

Hence, looking for ADVANCED help FROM Sr. Members, who are MUCH into tweaking etc.

Thnx
Sandy...
Reply With Quote
  #16  
Old 04-19-2004, 04:14 AM
Brad Brad is offline
 
Join Date: Nov 2001
Posts: 4,765
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Make sure you are serving css as a file, also strip out anything from the templates you don't need, or offer a stripped version for people on slower connections. I would also upgrade to the latest stable release of apache 2.0. Make sure the query cache is on for mySQL to, o yea and that gzip output is on.

Also go into the admin cp and shut off anything you don't need, things like access masks, or fetures no one ever uses on your board. Every little bit gose a long way.

One last thing, after every upgrade check the vB file versions via the admin cp. If you are like me and have to wait awhile on things to upload via ftp you tend to let things go on their own, my ftp client dose not overwrite old files sometimes for whatever reason. I had old .js files when I upgraded to gold, which caused errors and some slow down until I caught it and got the new ones on there.

I loaded your boards and honestly they aren't that slow on my 56k.
Reply With Quote
  #17  
Old 04-19-2004, 07:48 AM
SaN-DeeP's Avatar
SaN-DeeP SaN-DeeP is offline
 
Join Date: Jun 2002
Location: Mumbai, India
Posts: 1,195
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Brad.loo
Make sure you are serving css as a file, also strip out anything from the templates you don't need, or offer a stripped version for people on slower connections. I would also upgrade to the latest stable release of apache 2.0. Make sure the query cache is on for mySQL to, o yea and that gzip output is on.

Also go into the admin cp and shut off anything you don't need, things like access masks, or fetures no one ever uses on your board. Every little bit gose a long way.

One last thing, after every upgrade check the vB file versions via the admin cp. If you are like me and have to wait awhile on things to upload via ftp you tend to let things go on their own, my ftp client dose not overwrite old files sometimes for whatever reason. I had old .js files when I upgraded to gold, which caused errors and some slow down until I caught it and got the new ones on there.

I loaded your boards and honestly they aren't that slow on my 56k.
hi Brad.loo
This for YOUR HelpFul reply.

I have done foll. changes from ur reply

1. Enabled serving of css as a file.. into this dir -> vbulletin_css

2. Enabled GZIP with setting as 1

Few Questions:
how to strip off unwanted stuff from HTML ? i meant. its bit difficult for me to guess now. what i unwanted from DEFAULT installation with arcade hack..

Stable released of APACHE.. i would ask my HOSTING provider for that.

How to check if query cache is enabled on MYSQL.

I have disabled, users viewing this thread, etc. etc. access masks are turned off. no specific feature i am using @ the moment.

i have switched form invision to vb gold.. 3.0 hence, i guess. i wont have much trouble with any RELEASES which came after gold.

Please let me know if something more can be done.

I have also enabled, POST Cache features, with an option of 2 days set there.

Best Regards,
Sandy...
Reply With Quote
  #18  
Old 04-24-2004, 10:48 AM
SaN-DeeP's Avatar
SaN-DeeP SaN-DeeP is offline
 
Join Date: Jun 2002
Location: Mumbai, India
Posts: 1,195
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by SaN-DeeP
hi Brad.loo
This for YOUR HelpFul reply.

I have done foll. changes from ur reply

1. Enabled serving of css as a file.. into this dir -> vbulletin_css

2. Enabled GZIP with setting as 1

Few Questions:
how to strip off unwanted stuff from HTML ? i meant. its bit difficult for me to guess now. what i unwanted from DEFAULT installation with arcade hack..

Stable released of APACHE.. i would ask my HOSTING provider for that.

How to check if query cache is enabled on MYSQL.

I have disabled, users viewing this thread, etc. etc. access masks are turned off. no specific feature i am using @ the moment.

i have switched form invision to vb gold.. 3.0 hence, i guess. i wont have much trouble with any RELEASES which came after gold.

Please let me know if something more can be done.

I have also enabled, POST Cache features, with an option of 2 days set there.

Best Regards,
Sandy...
BUMP..
some more help is appreciated.
forums gained lot of improvements

what is sql cache ? as my question above

thnx.
Sandy...
Reply With Quote
  #19  
Old 05-02-2004, 12:30 AM
Pseudomizer's Avatar
Pseudomizer Pseudomizer is offline
 
Join Date: Mar 2002
Location: Germany
Posts: 614
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi Sandy,

after having looked through your server config i can not see any misconfiguration so far. I also went to your page. Your start page is HUUUUGE but it loads very fast. But when i go to your forum page there are 2 small stops during the load of the page. I would like to know why this is happening.

Could be due to too much queries or wrong code. I would suggest that you install this hack from Teck https://vborg.vbsupport.ru/showthrea...ght=microstats which will give you more information about the PHP and the MySQL load on your site.

In addition to this you will see which template is not cached and you can solve this afterwards.

So please install this hack and then we talk again. I think the others should agree to this rather then digging in the dark we should start to find the cause for this. Perhaps it is only one bad hack which you installed.

Cheers,
Reply With Quote
  #20  
Old 05-03-2004, 05:21 AM
Brad Brad is offline
 
Join Date: Nov 2001
Posts: 4,765
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Pseudomizer
Hi Sandy,

after having looked through your server config i can not see any misconfiguration so far. I also went to your page. Your start page is HUUUUGE but it loads very fast. But when i go to your forum page there are 2 small stops during the load of the page. I would like to know why this is happening.

Could be due to too much queries or wrong code. I would suggest that you install this hack from Teck https://vborg.vbsupport.ru/showthrea...ght=microstats which will give you more information about the PHP and the MySQL load on your site.

In addition to this you will see which template is not cached and you can solve this afterwards.

So please install this hack and then we talk again. I think the others should agree to this rather then digging in the dark we should start to find the cause for this. Perhaps it is only one bad hack which you installed.

Cheers,
Question, did you mean to put two div's on top of each other here?

HTML Code:
<!-- open content container -->
<!-- open content container -->

	<div align="center">
		<div class="page" style="width:100%; text-align:left">
			<div style="padding:0px 5px 0px 5px">

<br />




	<div align="center">
		<div class="page" style="width:100%; text-align:left">
			<div style="padding:0px 0px 0px 0px">
<!-- front page drop down menu and google -->
I could'nt bother looking through your html as much as I would like right now but that stood out to me.

Often times you will find speed can be improved with better html, it may be worth having a quick look over your templates and seeing if they vaildate (vaildation isent everything, but imo a good steaping stone). One thing I am doing is turning off the dhtml/js pop-ups, which speeds the board up on my line a lot, mind you I am on a 14k line (aka crap 56k).

Also you have that pop-up that comes up for un-regged users, this lags mozilla and IE for me, it gives the apperance that your forumhome loads very slow, and it is also anoying.
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 01:52 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.03953 seconds
  • Memory Usage 2,283KB
  • Queries Executed 14 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_html
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete