Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
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.

 

 

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