How to speed up vbulletin page load times

[Pandemikk]

Originally Posted by michelle86

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] ---------------



I sent you a PM

Those database errors are host problems. The first one means that there are most connections to the database then allowed. On a shared host you don't have permission to increase the maximum allowed connections. You can ask your host to increase this limit, but, most shared hosts will not do so.

The second simply means your mysql settings are too limited. The amount of resources needed is more than the amount allowed in your settings.

Your site seems to load fast enough for me. Not slow, not lightning quick. Very typical of a shared host.