We store the images on the file system instead of in the database.
We are currently doing both -- it's an application configuration issue for us (we tell our code which "Repository" object to use to load binary data). I would highly suggest doing the same -- put a layer of indirection so you're not married to either storage target. That way you can run with BLOBs on some databases, files on others (we're using BLOBs on Oracle, file system for all other database systems) depending on the performance you measure.
justin
-----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]
______________________________________________ Justin Ruthenbeck Software Engineer, NextEngine Inc. justinr - AT - nextengine DOT com Confidential. See: http://www.nextengine.com/confidentiality.php ______________________________________________
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
