saving images into file or database
Posted: Mon Mar 01, 2010 5:45 am
Hello,
I will be starting a new project and I need to decide if I am going to save uploaded documents(pdf and jpgs) into a file system of the database. The general idea seem to be to save it to the file system. But I love the idea to not deal with directories and just select the document from a database table. From a keep it simple, seems to be the way to go. BUT I am very concern, about long term. What problems could come up, by having all the docuemnts in the database? Could it be a good idea to create a separate database just for the documents? Should I just keep the on the file system? I will be running on 2 machines. A web server on the DMZ and the mysql server in the internal network. If I save the files on the file systems, it means I have to ftp the files to the mysql server(If I take the file system route), and maybe I have the ftp them back to present them to the user.
Anyone with prev experience on this, let me know. So far, when I upload documents, they are on the same machine as the web server, so moving documents from one machine to another , was never a concern.
Thank you
I will be starting a new project and I need to decide if I am going to save uploaded documents(pdf and jpgs) into a file system of the database. The general idea seem to be to save it to the file system. But I love the idea to not deal with directories and just select the document from a database table. From a keep it simple, seems to be the way to go. BUT I am very concern, about long term. What problems could come up, by having all the docuemnts in the database? Could it be a good idea to create a separate database just for the documents? Should I just keep the on the file system? I will be running on 2 machines. A web server on the DMZ and the mysql server in the internal network. If I save the files on the file systems, it means I have to ftp the files to the mysql server(If I take the file system route), and maybe I have the ftp them back to present them to the user.
Anyone with prev experience on this, let me know. So far, when I upload documents, they are on the same machine as the web server, so moving documents from one machine to another , was never a concern.
Thank you