Store (large) images inside or outside database?
Store (large) images inside or outside database?
- Subject: Store (large) images inside or outside database?
- From: Susanne Schneider <email@hidden>
- Date: Fri, 08 Feb 2008 10:58:07 +0100
Hi everyone,
<seems that all have moved to the apple-list, so I repost my message
here. Jerry, in any case thanks for the link.>
today I need some advice on a conceptual basis:
We need to include images in our WO 5.2.3 application working
with Oracle 9.i as a database. The images may be of various kind
including DICOM images and therefore could be very different in size
(maybe from 100 KB up to 100 MB or even more).
Besides the problem of handling such variety of formats I could not
really make up my mind if we should store such large objects in the
database and reflect them with eo-properties or store them in the
filesystem and only the pointer in the database. The images are treated
as read only: once they were uploaded they will be stored and only be
displayed for download/view. The image property would be put into a
separate table to be only loaded if needed. It is not possible to put
the images under webserver-control because they include sensitive
information.
These were my considerations:
- memory consumption while using eos (as I understood the image-property
would at least be hold twice: once in the eo in every editing context
and once in the snapshot)
- backup and recovery issues of the database
- transaction management
Any comments?
Susanne
--
Susanne Schneider
Coordinator secuSuite Development
iAS interActive Systems GmbH
Dieffenbachstraße 33 c, D-10967 Berlin
fon +49(0)30 69 00 42 - 05
fax +49(0)30 69 00 42 - 10
mail email@hidden
web http://www.interActive-Systems.de
----------------------------------------------------
Geschäftsführer: Dr. Marko Reschke, Thomas Fritzsche
Sitz der Gesellschaft: Berlin
Amtsgericht Berlin Charlottenburg, HRB 106103B
----------------------------------------------------
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden