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: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)