Home » Other » General » ADO : recordset vs cursor
ADO : recordset vs cursor [message #103811] Wed, 24 March 2004 07:46 Go to next message
jerome
Messages: 13
Registered: May 2000
Junior Member
Dear Experts,

I'm using(in C++) a SELECT statement in a Recordset (C++) to retrieve data from my DB (Oracle 8i). 

There are around 1 million records to be returned but when I performed the rs.Open , I can't get the 1 million records but only around 300.000 (the number of records returned change from one try to another).

I heard I should use a Cursor to perform that.

Is it the good solution ?

Any help greatly appreciated.

Jerome.
Re: ADO : recordset vs cursor [message #103812 is a reply to message #103811] Wed, 24 March 2004 10:38 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
One solution may be better than another for your situation - it's difficult to have ageneral "rule of thumb" though. See ref-cursors. The ref cursor handle will be passed to your C++ program and it will retreive the results as needed. Ref-cursors are relatively new - C++ programs have been accessing large amounts of Oracle data forever, so it's certainly not the only solution.

http://osi.oracle.com/~tkyte/ResultSets/index.html
Previous Topic: urgent help required
Next Topic: Force password change if NEW user ?!?
Goto Forum:
  


Current Time: Thu Mar 28 21:13:19 CDT 2024