Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Visual Basic
Expertise: Advanced
Jul 20, 2001



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Avoid Sending Unchanged Data Back to the Server For Updating

One of the best ways to improve performance in a distributed application is to avoid sending unchanged data back to the server for updating. I use the following strategy to determine if a disconnected recordset needs to be sent back to the server. Declare module level string and Boolean variables:
Private sRecord as String
Private bDirty as Boolean

When you first land on a new record, read it into the variable by calling SetRecord rsMyRecordset. SetRecord reads only the current record as shown:
Private Function SetRecord(rs As ADODB.Recordset) As Boolean
    '   Saves entire record as a single value for later comparison
    Dim i As Integer
 sRecord = 
Bob Feldsien
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date