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]

Originally Posted by Marco van Herwaarden

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

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

Originally Posted by 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

Originally Posted by 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

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

[pant]

Originally Posted by kawe

very thanks for comment
im already stored data to filesystem
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]

Originally Posted by Marco van Herwaarden

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]

Originally Posted by kawe

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?