At 01:11 PM 1/27/2004, you wrote:
>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:B.Shanta@(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: tomcat-user-unsubscribe@(protected)
>For additional commands, e-mail: tomcat-user-help@(protected)
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
>For additional commands, e-mail: tomcat-user-help@(protected)


______________________________________________
Justin Ruthenbeck
Software Engineer, NextEngine Inc.
justinr - AT - nextengine DOT com
Confidential. See:
http://www.nextengine.com/confidentiality.php
______________________________________________


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)