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 ??
User Profile
Collapse
-
-
BLOB performance impact
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...
No activity results to display
Show More
Leave a comment: