bcamp1973 Posted February 13, 2007 Share Posted February 13, 2007 Just curious...i'm creating a CMS that manages documents (.txt,.doc,.psd,.jpg) among other things. I know files can be dumped into a database, but i'm wondering if it makes more sense to drop them into directories on the server instead for performance or other reasons? Link to comment https://forums.phpfreaks.com/topic/38326-solved-uploading-files-to-directory-structure-vs-storing-in-db/ Share on other sites More sharing options...
fenway Posted February 13, 2007 Share Posted February 13, 2007 Depends... if you're accessing it from a single machine, then having the files managed by the disk I/O is much better than having them in/out of a DB. Link to comment https://forums.phpfreaks.com/topic/38326-solved-uploading-files-to-directory-structure-vs-storing-in-db/#findComment-183712 Share on other sites More sharing options...
bcamp1973 Posted February 14, 2007 Author Share Posted February 14, 2007 That definitely makes sense. I'm guessing the average file size is probably going to be under 100k so it won't be a huge difference I imagine? I won't be dealing with high user loads either. hmm...decisions, decisions Link to comment https://forums.phpfreaks.com/topic/38326-solved-uploading-files-to-directory-structure-vs-storing-in-db/#findComment-184324 Share on other sites More sharing options...
btherl Posted February 14, 2007 Share Posted February 14, 2007 You can store the files in the filesystems, and store metadata in the database. Then you get the best of both worlds - the power of SQL for searching metadata, plus the efficiency and ease of use of a filesystem for the files. Binary data is certainly better suited to the filesystem than a database. Link to comment https://forums.phpfreaks.com/topic/38326-solved-uploading-files-to-directory-structure-vs-storing-in-db/#findComment-184370 Share on other sites More sharing options...
fenway Posted February 14, 2007 Share Posted February 14, 2007 I totally agree. Link to comment https://forums.phpfreaks.com/topic/38326-solved-uploading-files-to-directory-structure-vs-storing-in-db/#findComment-184642 Share on other sites More sharing options...
bcamp1973 Posted February 14, 2007 Author Share Posted February 14, 2007 Filesystem it is then! Thanks to both of you! Link to comment https://forums.phpfreaks.com/topic/38326-solved-uploading-files-to-directory-structure-vs-storing-in-db/#findComment-184695 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.