dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


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

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


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