Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

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

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