Re: BLOB & JPEG images

Harshad Bahirsheth <harshad1_at_ix.netcom.com> writes:

>I need to store images(BMP and JPEG). My app is a Delphi/Oracle on NT
>combination. The bitmaps are abot 700K and the JPEGs are 250K. Would it
>be prudent to -
>1. Store the image files in a seperate directory and store the path names
>in the Oracle database OR
>2. Sotre the image in the Oracle database as a BLOB (LONG RAW) and not
>incur a significant penalty.
 

>What are the pros and cons of each case? I imagine this sort of thing is
>done very commonly. Any comments would be greatly appreciated.

In the systems we've been developing, we store a pathname in the database and the actual image data out in a file somewhere. This is useful since we're using this as part of a web application which needs to be able to convert images. It's more convenient to leave them in regular files, plus it keeps the size of our database down.

If, however, you wanted to move data around between separate databases, it might be better to store your image data as a BLOB.

-Shannon

--
Shannon Robert Madsen                                       madsen_at_cs.umn.edu
=============================================================================
   http://www.cs.umn.edu/~madsen      |       "ad astra per aspera"
=============================================================================
GAT d(-) s+:- a21 C+++$ USBAILXH++++$ P+++$ L+ E+ W+++$ N+++$ o? K++
w---$ O? M++$ V-- !PS !PE Y PGP+ t+++ 5++ X++ R- tv b++ DI++++ D+ !G e
h++(-)* r%* y+