Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> BLOB fields slow down queries

BLOB fields slow down queries

From: Big George <jbeteta_at_gmail.com>
Date: 26 Sep 2006 15:50:53 -0700
Message-ID: <1159311053.498058.123430@e3g2000cwe.googlegroups.com>


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! Received on Tue Sep 26 2006 - 17:50:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US