File Locations - database or file system?

[dweiss]

What are the pros and cons of choosing between storing uploaded files in the database versus using the file system? Is it better to use one or the other? Does the size of the file matter?

Thanks,

[Zachery]

If you can store your files in the filesystem it'd be be the better of the two option.

[1996 328ti]

I'm finding 1/2 of my sql filesize are attachments.
If I move my attachments to a file system, backing up my database will take less time. Although I will need to remember to backup my website more often.

[dweiss]

If you can store your files in the filesystem it'd be be the better of the two option.

Zachery -

Thanks. Is there any reason I might not be able to store the files in the file system? I'm running on a standard Linux/Apache setup.

-Danny.

[Steve Machol]

As long as yyou are not running PHP in Safe Mode or with open_basedir restrictions, this will work.