I am using a MFC CRecordset (ODBC consumer) and opening as a forward only. A standard select returns 50K to 100K of records for a 24 hour period.
On a local DB (low ping) this is fine, select + processing times under 2 seconds.
On a network DB (high ping) this blows out to 60-90 seconds (and this will be used from a remote site.....).
It appears the CRecordset still needs to communicate with the DB each time I move thru the records (slowing it down). Even using a SAO (snapshot) does not improve performance.
Any ideas to improve the speed?
Would moving to WIN32 help (anyone actually tried this)?
If I can get these queries down to an acceptable time I can colour this one done......Code:rsMain.Open(CRecordset::forwardOnly ,sSQL , CRecordset::readOnly | CRecordset::noDirtyFieldCheck);