Indexing and blobs

Post Reply
tboyer
Posts: 68
Joined: Mon Aug 28, 2006 4:43 pm

Indexing and blobs

Post by tboyer »

We are experimenting replacing some varchar fields with blobs to reduce table size. Figure it will improve performance on counts.

But performance seems slower if the table has been updated without being indexed.

Should we refresh Metamorph indexes more frequently if we're using a lot of blob fields? Is the performance penalty for blobs high if your indexes are not fully caught up?
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Indexing and blobs

Post by mark »

Blob fields are most useful when you rarely access them. If you're selecting the blob field you're actually causing more seeking and reading than for non-blob. So an out of date index will cause more disk activity if the query includes the blob field.
Post Reply