Skip to main content

T-SQL MSSQL Cursor performance

I was comparing the performance of different cursors in MS SQL

I was working with about 4 million rows in the following example


FORWARD_ONLY STATIC READ_ONLY
Apr 23 2015  4:50PM
CURSOR OPENED
Apr 23 2015  4:53PM
LOOP FINISHED
Apr 23 2015  4:53PM
DEALLALLOCATED
Apr 23 2015  4:53PM

FORWARD_ONLY FAST_FORWARD READ_ONLY
Apr 23 2015  4:53PM
CURSOR OPENED
Apr 23 2015  4:59PM
LOOP FINISHED
Apr 23 2015  4:59PM
DEALLALLOCATED
Apr 23 2015  4:59PM

FORWARD_ONLY KEYSET READ_ONLY
Apr 23 2015  5:00PM
CURSOR OPENED
Apr 23 2015  5:10PM
LOOP FINISHED
Apr 23 2015  5:10PM
DEALLALLOCATED
Apr 23 2015  5:10PM

FORWARD_ONLY DYNAMIC READ_ONLY
Apr 23 2015  5:10PM
CURSOR OPENED
Apr 23 2015  5:16PM
LOOP FINISHED
Apr 23 2015  5:16PM
DEALLALLOCATED

Comments

Post a Comment

Popular posts from this blog

Javascript Form Validation

It's real simple. All you need to do is call a javascript function in a html  " onsubmit " in the form tag as a javascript return, like this       <form method="post" action="dosomething.php" onsubmit="return validateForm();"> If the code completes ok, the form is then sent to the page listed in "action" http://www.w3schools.com/js/js_form_validation.asp If the function specified in the onsubmit returns false, then the form is not sent to the page mentioned in action.
Post a Comment
Read more