16:46
Unknown
Drawbacks of Cursors:
• Fetching a row from the cursor may result in a network round trip each time.
• Repeated network round trips can severely impact the speed of the operation using the cursor.
• Cursors allocate resources on the server, for instance locks, temporary storage etc.
• If a cursor is not properly closed, the resources will not be freed until the SQL session (connection) itself is closed. This wasting of resources on the server can not only lead to performance degradations but also to failures.
• Fetching a row from the cursor may result in a network round trip each time.
• Repeated network round trips can severely impact the speed of the operation using the cursor.
• Cursors allocate resources on the server, for instance locks, temporary storage etc.
• If a cursor is not properly closed, the resources will not be freed until the SQL session (connection) itself is closed. This wasting of resources on the server can not only lead to performance degradations but also to failures.
Posted in:
SQL Server Tutorial
0 comments:
Post a Comment