Re: BLOB fields slow down queries

On 26 Sep 2006 15:50:53 -0700, "Big George" <jbeteta_at_gmail.com> wrote:

>Hello,
>
>If I run this query:
>
>select MyID, MyDescription, MyblobField
>>From MyTable
>
>Brings 500 records but it takes 30 seconds !
>
>If I select without any blob fied like:
>
>select MyID, MyDescription
>>From MyTable
>
>It's fast.
>
>The blob fields are storing images like jpg or gif files.
>Approximately, each field stores 250 KB.
>I know that blob fields are slowing down the query, but could be any
>way to accelerate it?
>
>Thank you!

Make sure you store the lobs 'out-of-line' in their own tablespace.

--
Sybrand Bakker, Senior Oracle DBA