Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain segment?
Where can you find a list of object keys included in a transport?
Have you done any up gradations?
What will you do if u got Update failure?
What do you understand by sap client administration?
How to setup RFC connection in ecc6 tells me steps involved?
how can i change access to a user who is having access for SPRO display only to change access in sPro
When we are doing cash sales, free goods and discount, How many pricing procedure do we need to create..? Only one PP required or have to create multiple PP..? and how many condition type we need to create..?
Can anyone help me in educating me in installing SAP 4.6C over windows server 2000. Please make it a step by step process, my career depends upon the success and failure of installation.
How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.
What is an ‘ok’ code? What are the differences an ‘ok’ code to a ‘t-code’?
What is the difference between consolidation and development route ?
How many times bdls transaction executes for 2 clients
Is there a way to perform sapgui 640 roll out using a centralized server?
what is role of sap administrator in pi & ep?
