Answer Posted / ashwin mane
Cursors do provide a number of benefits. These benefits
follow from the fact that if you do not use a cursor, the
entire result set must be transferred to the client for
processing and display:
1.Client-side memory - For large results, holding the
entire result set on the client can lead to demanding
memory requirements.
2.Response time -Cursors can provide the first few rows
before the whole result set is assembled. If you do not use
cursors, the entire result set must be delivered before any
rows are displayed by your application.
3.Concurrency control -If you make updates to your data
and do not use cursors in your application, you must send
separate SQL statements to the database server to apply the
changes. This raises the possibility of concurrency
problems if the result set has changed since it was queried
by the client. In turn, this raises the possibility of lost
updates.
Cursors act as pointers to the underlying data, and so
impose proper concurrency constraints on any changes you
make.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why can't we do it thru some other client?
Do you know logon groups at which situation will be created logon group?
How can a user be able to access only for Customizing requests even if assigned se01 and se10?.
How you can assign an object to 100 roles at time?
Have you done any parameter changes using configtool and visual admin tool?
What are the different user types in sap system that an admin can use while creating a new user?
What is R/3? and what is basis version?
How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.
Transport request types and its syntax?
What is the difference between consolidation and development route ?
Is there a way to perform sapgui 640 roll out using a centralized server?
How do you generate (recover) old system logs in a newly created SLOG00?
When I check transaction sm37 and I want to see the spool I get a message that says "no list available." Why is this?
can we give one check for all vendors in automatic payment run? how?
suppose in the landscape there is development, quality, pre-production and production system is there. what is the route(transport route) between pre-production to production? and why?