BLOB performance impact

[CraCKerO]

Hello,

I have a question about blob performance in sqlServer 2008

I have a table that contains about 64 columns from which two columns are blob (image), my question is, will these blob columns have performance impact while passing select queries ?

is creating a table which will contain these blob columns separated (and remove them from original table) will increase significantly data access performance ?

btw, our scenario will hardly reach 300k rows per table

thank you,

[ck9663]

I'd still say you do some benchmarking. Logic says it would be better to separate this columns specially if these columns may or may not contain values. You can just insert a new row if those columns have values in them.

Good Luck!!!

~~ CK

[CraCKerO]

thank you for your answer, I will try some benchmark, for the time being I tried a select query which displays the blob fields and another select query that doesn't, the query with blob fields selected preformed 4 times slower than the other query without blob fields.
maybe because of displaying blob data on result window, that become this slow ??

[ck9663]

Doing a simple select could have some I/O factors in displaying the column on the result tab. Try doing a select into so as to remove the I/O portion of select statement.

Good Luck!!!

~~ CK