On Sat, Jul 11, 2009 at 4:35 PM, Michal Charemza<[email protected]> wrote: > This isn't an Agavi specific question, but I wonder what people here > think: > > Should uploaded files be stored in a database, or the file system? If > it's relevant, I will have 2 sorts of files: > > - Publicly viewable files available to all > - Files that are only visible to users with specific download > privileges. > > What do people think is the best way of storing these files? >
Whatever floats your boat, man... If you ask me, I'd rather store the files as flat files because it keeps the DB small, and it makes file access faster. I'll only store the paths in the DB. Keeping the files as flat files gives you the option of putting them into a separate partition where you can scan it, compress it, limit its disk space, etc... [ simon.cpu ] _______________________________________________ users mailing list [email protected] http://lists.agavi.org/mailman/listinfo/users
