http://forum.vbulletinsetup.com/f7/v...on-tips-2.html 4. Move Attachments to the File System
Stock vBulletin Attachments are stored in the Database. Large attachments or frequent viewing of them can cause a strain.
To move them to the File System, create an attachments directory above your public_html (at the same level as it.. /root/username/public_html | root/username/attachments) and CHMod it 777.
By placing it at this level, we prevent anyone from being able to access the attachments directly (ie: not through vBulletin).
Next, go to the
AdminCP and expand the
Attachments menu.
Click on
Attachment Storage Type.
Move your attachments out of the database and into the file system.
Attachment Path: /home/*username*/attachments 5. Move Avatars and Profile Pics to the File System
As with the Attachments above, but the Avatars are on every post, so cause a burden to the server whenever a post is viewed.
To move them to the filesystem, chmod your forums/customavatars and forums/customprofilepics directories to 777.
Go to the
AdminCP and expand the
Avatars menu.
Click
User Picture Storage Type.
Choose to
Move Avatars and Profile Pics to the File System.
Avatar Path: /home/*username*/public_html/forums/customavatars Avatar URL: /forums/customavatars Profile Pic Path: /home/*username*/public_html/forums/customprofilepics Profile Pic URL: /forums/customprofilepics
I'd suggest reading over that thread, there are many tips to help you out.
btw, I would close a thread with 10,00 replies.. it's a resource hog