Hi Lauren,
>Does this mean you (or the DB) retrieve the object
>from from the database and save it to the file
>system (in the document root)?
That is correct.
> I would think this would be relatively slow. I understand you said
Informix has a
> function to do this for you, and this may speed up the process
Actually, this is very fast, specially if the database and the app
server are on the same box, but even when they are not, performance is
very good.
> I would think this wouldn't be particularly scalable.
We have done some testing during our application development comparing
the use of this system against the more traditional method of having a
servlet retrieve the blob data using JDBC and performance is much
better, specially with large blobs.
Huibert Aalbers
Lauren Commons wrote:
> Question below...
> --- Huibert Aalbers <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I have recently done what you are looking for using
> > (not surprisingly if you
> > take a look at my e-mail) an Informix database. I
> > stored the images as blobs in
> > the database and used a singleton class (called
> > through a JSP custom tag) to
> > retrieve the images to the file system ...
>
> Does this mean you (or the DB) retrieve the object
> from from the database and save it to the file
> system (in the document root)? I would think this
> would be relatively slow. I understand you said
> Informix has a function to do this for you, and this
> may speed up the process, but I would think this
> wouldn't be particularly scalable. Though it could be
> fine for a low-volume app....
>
> just wondering.
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35
> a year! http://personal.mail.yahoo.com/
