devxlogo

Avoid Sending Unchanged Data Back to the Server For Updating

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 StringPrivate 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 =

See also  Small Business Strategies with Venmo
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist