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!
And you need to put 500 (x 250K = 125MB) blobs into memory at one time
why?
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Tue Sep 26 2006 - 18:06:01 CDT
