Re: Pictures in Oracle

 Hi,
 How about BFILE datatype?
 Also BLOB shouldn't slowdown performance. May be you store BLOBs in the same tablespace with table data? In this case performance will be down.
 Also I recommend you keep pictures as BFILE is they are used by other applications and use BLOB if the are not (only Oracle use them).  I don't recommend you use own methods as saving filename in VARCHAR2 and picture in file because you'll face problem in clients applications. In this case how you show picture? Using BLOB you can use SQLGetData function for retrieving pictures.

In article <3A635044.AAB392AB_at_mail.gov.nf.ca>,   Howard Purchase <howardp_at_mail.gov.nf.ca> 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.
>
> Howard Purchase
> Dept of Justice
> Gov't of Newfoundland and Labrador
>
>

--
Best regards, Dmitry


Sent via Deja.com
http://www.deja.com/