BLOB & JPEG images

From: Harshad Bahirsheth <harshad1_at_ix.netcom.com>
Date: 1996/12/02
Message-ID: <32A386ED.29CF@ix.netcom.com>#1/1

Hi,
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.

Thanks,
Harshad Bahirsheth
harshad1_at_ix.netcom.com Received on Mon Dec 02 1996 - 00:00:00 CST