I'm working on a webbased file archive, and I'm not sure if I should make it store the different filetypes in a mysql database or a folder on the server!

Which solution is the fastes to view / work with?

(Have heard that files in databases makes queries very slow)

David

10-10-2012, 03:28 PM

NogDog

Unless you need to be able to search/sort the actual file contents, I generally prefer to let the file system handle file storage and let the database system handle data storage. You may, however, want to store the actual files on the file system while storing data about the files in the database (author or owner, file type, descriptions, etc....), which may include the actual directory/filename info so you know which file to access based on your DB query results.