Ado Recordset MoveNext() in .NET very slow?
How comes that when I receive a ADO Recordset (with about 70.000 records) from an VB application in my .NET application, the 1st example takes only 6 sec, whereas the 2nd example takes over 150 sec?
1st:
dynamic recordset = myVBObject.GetRecordset();
recordset.GetRecords();
2nd:
dynamic recordse开发者_运维技巧t = myVBObject.GetRecordset();
while (resultComObject.AbsolutePosition != ADODB.PositionEnum.adPosBOF && resultComObject.AbsolutePosition != ADODB.PositionEnum.adPosEOF)
{
resultComObject.MoveNext();
}
Is there any way to make the moving through the records faster ?
精彩评论