Re: Slow performance on Long Raw Datatypes, Help !

Kenny,

Are you committed to putting the JPGs in the database. Our studies, based on act

ual benchmarks and talking to some vendors that have wrestled with this question themselves has led us to believe this is not the way to do it.

Most systems maintain binaries on a file system and admin info in the database. Not a symmetrical solution granted but a very fast one.

Sal
steeldb_at_hotmail.com

Kenny Leow wrote:

> Hi,
>
> Currently, I am inserting jpeg files into my table people_photo. It contains
> a member_id varchar2(7) and photo_rec Long Raw. Member_id is the primary key
> of the table people_photo.
>
> I am experiencing slow performance while inserting into the table.
> Basically, an insertion of about 200 photo takes about 5 hours. I am using
> Powerbuilder to insert the images and commit until all insertion is
> finished.
>
> Can anyone advise how can I improve the performance. I am out of my wit.
>
> Thanks a lot.
>
> Please reply to leow_at_stcs.com.sg. If you had the solution. Thanks again.
>
> Kenny
Received on Sat Nov 28 1998 - 09:18:02 CST