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)
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.
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
Reply With Quote
Bookmarks