Re: Improving performance of a BLOB question

From: amogh <amogh.r_at_gmail.com>
Date: Fri, 21 Apr 2006 10:35:05 +0530
Message-ID: <i%Z1g.34$9f2.155@news.oracle.com>

Robert wrote:
> Greetings,
>
> I have been working with a group who has a web application that queries a
> 4 field table. One field data type is a long. The attachments contain
> multiple screenshots and other misc. data for SOX requirements. I have been
> told that the record can have up to 100 Meg of data attached. The
> performance when retrieving BLOB data has gotten dismal. I am wondering if
> there are techniques, suggestions, configurations, white papers, books, etc.
> than can be considered to improve performance during a query?!
>
>

>I am wondering if there are techniques, suggestions, configurations, >white papers, books, etc. than can be considered to improve performance >during a query?!

Have you taken a look at the docs on LOB performance here: http://download-west.oracle.com/docs/cd/B19306_01/appdev.102/b14249/adlob_performance.htm#i1007089

If you are using a programatic interface(like OCI/OCCI) to fetch the LOBs, use prefetching. Prefetching does help improve performance based on the number of LOB rows you are fetching.

Rgds.
Amogh Received on Fri Apr 21 2006 - 00:05:05 CDT