|Subject:||BLOB fields slow down queries|
|Posted by:||Big George (jbete…@gmail.com)|
|Date:||26 Sep 2006|
If I run this query:
select MyID, MyDescription, MyblobField
Brings 500 records but it takes 30 seconds !
If I select without any blob fied like:
select MyID, MyDescription
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?