Attachments
 

What do you lot think the best storage type for attachments is, database or in a folder (chmod 0777)?

Regards Jason :)

I prefer folder personally. If I spent more time optimizing mysql or it was on it's own box then maybe I'd answer differently.

Generally I try to minimize calls to the db as much as possible.

But that might just be witchcraft and I don't really know so sorry I couldn't help!

Hmm, I may try a folder. Can you get all attachments currently in the database to a folder?

Regards Jason :)

Storing them in a folder outside of the webroot is by far the best way, just remember if you ever move servers to move the attachment folder too.

And if you go under attachment options in the adminCP you'll see attachment storage type, and there you can move them all to a folder on your server

yes - from admin cp

you'll need to set up the directory you want to store everything in though obviously - good advice from FRDS on where exactly.

Why is it by far the best way?

It's the best way because if they are outside of the webroot, then they are not accessible at all to the outside world. My attachments are in "/home/mysitename/attachments/" and my site is at "/home/mysitename/public_hmtl/" No one can get to my attachments except through vbulletin and using the vb permissions system. Just don't forget that when you store attachments/avatars/profiles in the file system, they will not be backed up when you do a database backup. You must back them up separately.

Hello,

I've moved all album pics, avatars, attachments, signature pics ect. to a file system, as I'm very minimalist and try to optimize the database as much as possible.

One question, is it safe for me to delete the tables that are left from things such as avatars, attachments, ect.?

Regards Jason :)

Do NOT delete any of those tables.