PDA

View Full Version : Quantity of vBadvanced DB connections?


MortysTW
02-13-2006, 07:03 PM
My host is saying my website is really hogging the server. I can't seem to find anything wrong but it appears my website is making WAY too many db connections.

I think it might be my vbadvanced front page. Its a bit busy.

But curious, how many times does vbadvanced connect to the db?

If I have on the same index page, Latest Jokes, Latest Posts, Latest Pics, Latest Discussions and they ALL use the typical default Latest Discussions, but the other's are just displaying different forumID's is that page connecting multiple times to the db to get the connections? Or is each user only connecting once and all info is spread evenly across the modules?

Understand what I'm getting at?

Does 5 Latest Discussion modules on the same page equal 5 connections to the DB or just 1 connection?

Brian
02-13-2006, 08:19 PM
The number of queries is going to depend on what modules you have active, but yes, you will have an additonal query on the page for each copy of the recent threads module. I would suggest checking your includes/config.php file and make sure that your $config['MasterServer']['usepconnect'] option is set to 0. Other than that, you could try adding this line near the bottom of your config.php file:

$config['Misc']['debug'] = '1';

Then go to http://www.mortystwistedworld.com/index.php?explain=1 and post the results of that here.

Another thing you may want to look into is Flashchat. The last I checked that script could be somewhat server intensive if you have a significant number of people chatting.

Our Sponsors
 

MortysTW
02-13-2006, 09:07 PM
Well, the page has tons of stuff on it. What should I post specifically?

This was at the very bottom.

Page generated in 1.37480 seconds with 48 queries, spending 0.24722743034363 doing MySQL queries and 1.1275725696564 doing PHP things.

So ya, 48 queries per user ads up a bit

Brian
02-15-2006, 02:46 PM
Yea, something doesn't seem right. I would need to see the entire page though.

Our Sponsors
 

MortysTW
02-15-2006, 07:38 PM
http://www.MortysTwistedWorld.com is the page.

But going by how many "Latest" modules I have going on, it doesn't exactly seem wrong either.

I don't really want to leave that information wide open. I'm home all night, reply and I'll see the email notification and quickly turn it on and come running back here to let you know its on. Only coordination I can think of.