PDA

Click to See Complete Forum and Search --> : Server Side & Client Side Cursors


kovan
Aug 24th, 2000, 07:07 AM
i been reading books, examples ect
i cannot grasp a detailed difference between the 2..

can someone try to explain them
and maybe give a example of where each is appropriate
thanks

JHausmann
Aug 24th, 2000, 11:20 AM
Essentially the cursor is describing where the work (sql DML) will be called.

Client side cursors - batch operations, disconnected operations, high performance when bound to complex controls

Server side cursors - performance, multiple open cursors, less memory required, more cursor types.