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

Popular posts from this blog

NMAP

It's been about 15 years since I used NMAP, I forgot how useful the tool is. To find out what services are running on an IP address simply use something like nmap -n -v -p1-10000 x.x.x.x -n tells nmap not to do name resolution (saves about 13 seconds if the IP you're scanning isn't in DNS_ -v verbose -p1-10000 says scan ports 1 to 10,000 (otherwise nmap will only scan the first 1000 ports)