Ask About Forum Performance with Attachements

[kawe]

Hai, i want to ask about forum performance if i enabled ATTACHEMENT on my forum
attachement not stored on MySQL Data, i already create a new folder under forum root directory for stored all attachement.

if true or not the attachement will affect to forum performance ?

[Marco van Herwaarden]

IT does have an effect, but should be a positive effect as it doesn't strain the MySQL as much.

[kawe]

IT does have an effect, but should be a positive effect as it doesn't strain the MySQL as much.

ah okey thanks
but, for 7000 members/day can you give me suggestion
i must turn it on or turn it off :D the attachments feature

[Marco van Herwaarden]

Regardless of the number of members it is mostly advised to move attachments to the filesystem.

See also the manual: Attachment Storage Type (http://www.vbulletin.com/docs/html/attachment_storage)

[pant]

Yeah mate I would suggest you move everything across to the file system rather than keep it in your database.

Our forum is reasonably sized but has a lot of attachments. It was pretty easy to move avatars/profile pictures/signatures and attachments to the filesystem and page loads are definitly snappier.

If you want any help give me a shout.

Make sure when you you're creating your attachments directory that it is above your Public HTML. So for example the following would be bad.

home/username/public/attachments/ BOOOOOOOOO

This would be good

home/username/attachments/ YAYYYYYYYYYY

The reasons are documented anyway but if you do the former then your usergroup permisions for attachments can be bypassed. If you do the latter then this isn't the case and your attachments are safe :)

MEOW

[kawe]

Regardless of the number of members it is mostly advised to move attachments to the filesystem.

See also the manual: Attachment Storage Type (http://www.vbulletin.com/docs/html/attachment_storage)

Yeah mate I would suggest you move everything across to the file system rather than keep it in your database.

Our forum is reasonably sized but has a lot of attachments. It was pretty easy to move avatars/profile pictures/signatures and attachments to the filesystem and page loads are definitly snappier.

If you want any help give me a shout.

Make sure when you you're creating your attachments directory that it is above your Public HTML. So for example the following would be bad.

home/username/public/attachments/ BOOOOOOOOO

This would be good

home/username/attachments/ YAYYYYYYYYYY

The reasons are documented anyway but if you do the former then your usergroup permisions for attachments can be bypassed. If you do the latter then this isn't the case and your attachments are safe :)

MEOW

very thanks for comment
im already stored data to filesystem :D
this attachments will be affected on BANDWITH REQUEST to server ?
if member view / download the atachments.

[pant]

very thanks for comment
im already stored data to filesystem :D
this attachments will be affected on BANDWITH REQUEST to server ?
if member view / download the atachments.

Not quite sure what you mean mate, bandwidth won't be affected though.

[Marco van Herwaarden]

Regardless where they are stored, they will always have to be sent to the user, so bandwidth is always consumed.

[kawe]

Regardless where they are stored, they will always have to be sent to the user, so bandwidth is always consumed.

thanks :)
i just wait and see
if my forum going slow after enable attachments
i will disable it xD

[pant]

thanks :)
i just wait and see
if my forum going slow after enable attachments
i will disable it xD

If anything your forum will run faster because your not querying the database to serve the attachments. Also, have you moved the avatars (these can be in your PUBLIC HTML)etc into the file system too?

[kawe]

If anything your forum will run faster because your not querying the database to serve the attachments. Also, have you moved the avatars (these can be in your PUBLIC HTML)etc into the file system too?

yess avatar, signature, profilepic already on folder system :D
not on database

[pant]

yess avatar, signature, profilepic already on folder system :D
not on database

Good job mate.

I only recently moved everything into the file system and our users have noticed an improvement in page load times.

[kawe]

Good job mate.

I only recently moved everything into the file system and our users have noticed an improvement in page load times.

also using xcache, mod_expires, and other tweaks :D
very fast page load times ( actually depends your connection :( )

[pant]

What's your site, I'm on fibre here :)

[kawe]

<a href="http://kontekaja.com" target="_blank">http://kontekaja.com</a>