Problems scrolling in MFC recordset 
Author Message
 Problems scrolling in MFC recordset

Serious performance problems with ODBC/Access/Win NT 4.0.

When scrolling past the last record in a CRecordSet for a IsEOF() check
the ODBC driver uses 1-2 minutes to return. It starts some havely disk
operations. Why? What is the database/recordset doing?
The table in the database is fairly big (50000 records), but the
recordset is filtered down to ca. 10 records when opened (no sorting).

ex. code:

while (!r.IsEOF())
 r.MoveNext();

Anyone familiar with this problem?

- Haarek Ryeng



Mon, 28 Jun 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. MFC recordset AddNew identity column problem

2. Problem with ADO recordsets of recordsets under MTS

3. Problems with built-in scrolls in dialogs (MFC)

4. Scrolling Through Recordsets Returned by a Stored Procedure

5. Attached a scroll-bar to MainFrame..Scrolling problem..

6. MFC ADO Async Recordset

7. Migrating from MFC Recordsets to ???

8. MFC ODBC Recordset Access 7.0 Bug

9. dynamic recordsets in mfc 4.2?

10. Cannot create MFC recordset using Oracle 9i and Visual Studio .NET

11. ADO recordset limitation (MFC)

12. MFC to ADO recordset

 

 
Powered by phpBB® Forum Software