Jump to content

Home

Avatars


Recommended Posts

the reason for the the bad connection/server down was because of.....THE AVATARS!!!!!! so i won't reallly CARE if we get them back or not. anyways

 

Originally posted by matt-windu

For this post I assume that avatars and sigs were turned off to help with the frequent database problems.

 

In case none of you know about the complexities of vBulletin, I'll fill you in...

 

The avatars and sigs are stored IN the database. We'll ignore everything except sigs for now. Say 20 posts in a thread, each poster has an avatar. Each time someone views the page, avatar.php is called and a new database connection is established FOR EACH AVATAR ON THE PAGE. So 20 posts, say 10 people reading the thread...that's 200 queries, just for ONE thread. Multiply that by about 10 for each forum...2000 x 15 forums...that's 30000 connections :eek:

 

Of course, not everyone loads the page at the same time, so that number is a bit huge ;)

 

Basically, bear with us.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...