Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> BLOB fields slow down queries
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
![]() |
![]() |