title: Can ADO on C++ platform be used to query a range of records? E.g. 100 records per query?
body: <p>I am using c++ with ADO to connect to a mySql database, and I am using the standard ADO/C++ method to create a connection to the mySql database, and <code>recordset</code> is the pointer to the retrieved first record</p>
  
  <pre><code>_RecordsetPtr recordset;
  recordset-&gt;Open("Select * from table",p_connection_.GetInterfacePtr(),adOpenForwardOnly,adLockReadOnly,adCmdText);  
  </code></pre>
  
  <p>My concern is if the table contains too many records, and if I query all records, it will consume alot of memory? </p>
  
  <p>I want to only retrieve, maybe 100 records each time and process them. Is it possible? The table does not contain id or index as its attribute, so "Select * from table where id >= 1 and id &lt;= 100" does not work.</p>