开发者

What is the quickest way to end a transaction when no changes have been made?

I'm using SQL server 2008 R2, and the function OpenSqlFilestream to obtain a file handle to open a file with read only access. I need this to be as开发者_如何学编程 quick as possible. OpenSqlFilestream requires being called within a transaction context, even though I won't be committing any changes to the file. Once I have done with the file I need to get rid of the transaction. What would be quicker, a commit or a rollback and why? Or is there some way to simple discard the transaction? I will not be modifying any rows or the file itself.


Found a discussion here already: Should I commit or rollback a read transaction?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜