Re: Pictures in Oracle

From: Chris Kasten <kasten_at_pobox.com>
Date: Mon, 15 Jan 2001 16:56:15 -0700
Message-ID: <ke376tgij4rvtkfhgqmrbmddo2p42rooal@4ax.com>

Howard Purchase <howardp_at_mail.gov.nf.ca> allegedly wrote:

> Hi,
>
> I need to know the most efficient way to store pictures in Oracle.
>
> I have tried a blob in a table that has a lot of rows, and it slowed
> down the table to the point where I had to remove the column with the
> pics.
>
> Any help will be greatly appreciated.

How 'bout the old fashioned low-tech way? Put the pictures anywhere on disk or server(s) and use a field in the table to point to the picture's location.

Ok, not real flashy but back in my day... :-) Received on Mon Jan 15 2001 - 17:56:15 CST