Discussion on:
View:
Show:
You are not giving the whole story here. It may be true that the cursor performed less logical reads then the while loop however at what cost to CPU, memory, blocking and concurreny. In a highly concurrent OLTP system basing your choice on logical reads alone won't get you anywhere. Also how many logical scans did each do?
Everything else was the same besides the logical reads.
How would you have gone about comparing them?
How would you have gone about comparing them?
I can't imagine a scenario where I should be using a cursor (e.g. iterating through a set of records) where I'd use a while loop, any potential performance gain (dubious at best in my opinion), would be totally offset by an increase in complexity and fragility.
Try to use a set based approach instead of a cursor is fine, a while loop?. Barking mad.....
Try to use a set based approach instead of a cursor is fine, a while loop?. Barking mad.....
Hey Tony,
Are you saying that you'd prefer to do a while loop over the cursor?
Tim
Are you saying that you'd prefer to do a while loop over the cursor?
Tim
If I was operating on a recordset I'd use a cursor. If I was repeating an operation while some condition, then I'd use a while loop.
I'm also saying that if I can avoid using either I will.
I also can't see any worthwhile gain in using while instead of a cursor or vice versa, just going to confuse the hecik out of the poor chump who has to maintain it next. If a performance improvement was desirable I'd engineer out the loop or cursor. As far as I'm concerned swapping would either be correcting an error or a nasty hack.
I'm also saying that if I can avoid using either I will.
I also can't see any worthwhile gain in using while instead of a cursor or vice versa, just going to confuse the hecik out of the poor chump who has to maintain it next. If a performance improvement was desirable I'd engineer out the loop or cursor. As far as I'm concerned swapping would either be correcting an error or a nasty hack.
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
