How to speed up vbulletin page load times

[michelle86]

Originally Posted by Pandemikk

102 kb is not big at all. There's no reason why it should take a modern user more than a second, maybe two, to load that.

It really doesn't take more than a couple seconds to load. I don't really know why my members are complaining so much. So many of them were saying it was slow, I was thinking that maybe there's a problem if so many are complaining.

But if 1-2 seconds to load is OK, then I guess I don't have to worry about speed?

Just focus on these database errors I get once in awhile.

Here are a couple errors. The database errors happen roughly between 1-4am EST almost every night from what my members tell me. Sometimes I'm up that late to catch it. I don't always get an email when they happen, but here are the last couple that I did get emails for:

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User ******* already has more than 'max_user_connections' active connections
/home1/*****/public_html/members/includes/class_core.php on line 315

MySQL Error :
Error Number :
Request Date : Friday, March 23rd 2012 @ 11:22:47 PM
Error Date : Friday, March 23rd 2012 @ 11:22:47 PM
Script : http://************/mgc_cb_evo_ajax.php
Referrer : http://************/forum.php
IP Address : 72.87.142.139
Username :
Classname : vB_Database
MySQL Version :

And another random one from awhile back:

Database error in vBulletin 4.1.8:

Invalid SQL:

SELECT alb.albumid, att.attachmentid, att.userid, att.caption, att.dateline, att.state, fdt.filesize, IF(fdt.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fdt.thumbnail_dateline, fdt.thumbnail_width, fdt.thumbnail_height, u.username
FROM album AS alb
LEFT JOIN attachment AS att ON alb.albumid = att.contentid
LEFT JOIN filedata AS fdt ON att.filedataid = fdt.filedataid
LEFT JOIN user AS u ON att.userid = u.userid
WHERE alb.state = 'public' AND att.contenttypeid = '8'
ORDER BY rand(869630)
LIMIT 6;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Request Date : Tuesday, January 10th 2012 @ 08:18:47 PM
Error Date : Tuesday, January 10th 2012 @ 08:20:52 PM
Script : http://************/content.php
Referrer : http://************/usercp.php
IP Address : 74.243.173.27
Username : *****
Classname : vB_Database
MySQL Version :

--------------- Added [DATE]1332824941[/DATE] at [TIME]1332824941[/TIME] ---------------

Originally Posted by Pandemikk

It would help to have a link to your site.

A load time of nearly 6 seconds is unacceptable.

I sent you a PM

--------------- Added [DATE]1332825482[/DATE] at [TIME]1332825482[/TIME] ---------------

Originally Posted by Pandemikk

It would help to have a link to your site.

A load time of nearly 6 seconds is unacceptable.

I just tested your site (body bags) with that first speed test and it says:

Load Time: 6.574s
First Byte: 0.656s
Start Render: 3.538s

So maybe it isn't very accurate?