|
Disadvantages of cursor.- Cursor manipulates records row by row.
- It requires temporary storage for row manipulation.
- Thus manipulating a row using a cursor is costly affair since it consumes extra resource.
- Fetch record row by row means server roundtrip that consumes network recourses.
- Cursor requires a network roundtrip each time it fetches a record, thus consume network resources.
- While data processing, it issues locks on part of the table, or on the whole table.
- It uses more resources because each time you fetch a row from the cursor, it results in a network roundtrip.
- There are restrictions on the SELECT statements that can be used.
- Performance and speed is slow because of the round trips.
|
What are the different types of Locks?Shared Lock: Shared locks are used for operations that read data, such as a SELECT statement. During Shared locks used, concurrent transactions can read a resource, but cannot modify the data.......
