priyanshi bhardwaj wrote:I guess I should go for the first option in large projects. Thanks!! Everyone
Are you sure you want to go with point 1 on a large project? Here are a few questions and points to think about:
1. Who is going to administer the folders where your pictures will reside? You may need more people involved to administer you project. If you go with the separate images folder no matter where it resides, and depending on the size of your org, the application, you could be needing a small army to support the app when it is ready to golive. (DBA's, Web server admin, file storage admin, network admin).
2. Where are these pictures going to reside if you go with the file store option? If they reside on the same server they could bring you server down by filling space up with the images (unnecessary risk). If they go on another server, and that server goes down, you loose your images. Also if this is a web application, and you have the images on a different server you could have cross domain issues.
3. Transnational issues have already been mentioned already by Rob Spoor.
4. People who should not have access to you images will now have access to them, which could offend people and affect peoples privacy (As daft it may sound the image can be seen as data, depending on the nature of you application and business could therefore be subject to data protection).
Will it really be quicker to get the image from a file store, I don't thinks so, here's why, you still have to go to the database to find out where the image is stored before you can get the image. You could base64 the image and store it in a clob or varchar column (depending on the image size), and therefore not have to worry about the file format after it is saved.
cheers
Q