Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: BLOB fields slow down queries
Why don't you use a secondary query to grab the blobs you really need
once you've identified them with a preliminary query? It will clearly
more time effective.
Big George 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!
Received on Wed Sep 27 2006 - 08:44:49 CDT