BLOB fields slow down queries

Giganews Newsgroups
Subject: BLOB fields slow down queries
Posted by:  Big George (jbete…@gmail.com)
Date: 26 Sep 2006

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!

Replies