<div>
Gee, that's great ..<br />
I never knew that ther's such a feature in ADO. It really works great... The performance has drastically increased..<br />
Thanx,<br />
Bye.
</div>


Gee, that's great ..
I never knew that ther's such a feature in ADO. It really works great... The performance has drastically increased..
Thanx,
Bye.

<div>
<div class="content wysiwyg-content">
Can anybody give me quick hints as to how I can increase the performance of my transactions. What I do is I open e recordset, which fetches around 500-600 records. I have heavy processing to do on these records, which &nbsp;are primarily extensive calculations. Because of these heavy calculations, the whole process takes a lot of time. I loop thru the recordset and process/updat each record. Can anybody throw some light on how I can increase my performance? Any help is appreciated..<br />
Me.
</div>
</div>


Can anybody give me quick hints as to how I can increase the performance of my transactions. What I do is I open e recordset, which fetches around 500-600 records. I have heavy processing to do on these records, which  are primarily extensive calculations. Because of these heavy calculations, the whole process takes a lot of time. I loop thru the recordset and process/updat each record. Can anybody throw some light on how I can increase my performance? Any help is appreciated..
Me.

Slow Recordset Performance

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.