Re: Pictures in Oracle

From: Van Messner <vmessner_at_bestweb.net>
Date: Tue, 16 Jan 2001 00:18:15 GMT
Message-ID: <brM86.368$Pr2.34284@monger.newsread.com>

Hi Howard:

I'm curious about the slowdown you experienced. BLOBs are stored separately from the other table data, often in their own tablespace. When you scan the table and hit a BLOB, all you're supposed to be scanning, is the location of the BLOB data - not the entire BLOB.

What happened to slow you down so much?

Van

PS the other poster is right. You can just store a pointer in a VARCHAR2 or whatever, but you don't get any of the Oracle "benefits" if you do. In particular, Oracle does not even check to see whether the location you're pointing to actually exists.

"Howard Purchase" <howardp_at_mail.gov.nf.ca> wrote in message news:3A635044.AAB392AB_at_mail.gov.nf.ca...
> 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.
>
> Howard Purchase
> Dept of Justice
> Gov't of Newfoundland and Labrador
>
Received on Mon Jan 15 2001 - 18:18:15 CST