Ryan Singer

My feedback

  1. 939 votes
    Sign in
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    19 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ryan Singer commented  · 

    Without FILESTREAM delete operations against tables with lots of large BLOB data take far longer.

    Our on-prem DB performs deletes many orders of magnitude faster because of this. A delete operation that takes 20:02 in azure sql takes 6 seconds on-prem because we can use FILESTERAM to make the BLOB deletion asynchronous.

    Perhaps most importantly we gain this performance with almost no code changes required as the sync is handled by the database, instead of our code.

    This feature seems like a no-brainer if you want people to move from on-prem to PaaS.

Feedback and Knowledge Base