Shanta, We store the images on the file system instead of in the database. A couple things to conspired are:
Images in the database will severely bloat up your database backups - exports etc. Having the images/documents in the database would be more secure because someone would have to get passed the database login to get to the files. There may be a speed difference - depending on if the database caches blobs Other than that, it is a personal preference question. Of course, this has nothing to do with Tomcat though. Chuck -----Original Message----- From: Shanta B [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 9:26 AM To: 'Shapira, Yoav '; 'Tomcat Users List ' Subject: design issue ..... Hi I have a requirement .....we have to develop a webservice ....Following is our requirement. 1)Client will send SOAP/HTTP request for imge(s). 2)We have(Service) to serve the corresponding image(s) through SOAP/HTTP. Now the design issues... ------------------------ I have two types of solutions... Type-1 ------- 1)Storing images in Database as a BLOB. 2)Extract the images and send it over SOAP/HTTP Type-2 ------- 1) Store the images on the hard disk with a predefined path and format, and store the reference (access path) in the Oracle database. 2)Get the relative path and get image and send it over SOAP/HTTP. could u please tell me which one is better interms of performance and scalability.We are using J2EE/J2SE/AXIS and Tomcat. Thanks Shanta.B --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
