User Profile

Collapse

Profile Sidebar

Collapse
CraCKerO
CraCKerO
Last Activity: Sep 3 '10, 09:29 AM
Joined: Jul 27 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • CraCKerO
    replied to BLOB performance impact
    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 ??
    See more | Go to post
    Last edited by CraCKerO; Jul 29 '10, 03:52 PM. Reason: typo

    Leave a comment:


  • CraCKerO
    started a topic BLOB performance impact

    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...
    See more | Go to post
No activity results to display
Show More
Working...