• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 21. Client/Server Strategies > Optimizing Data Handling

Optimizing Data Handling

One of the best things you can do to optimize data handling—such as edits, inserts, and deletes—is to add a Version field (timestamp) to each remote table. This Version field is employed when users update the data on the remote table to avoid overwrite conflicts. If this field does not exist, the server compares every field to see whether it has changed since the user first began editing the record. This is quite inefficient and is much slower than evaluating a timestamp.

Using transactions is another way to improve performance significantly, because transactions enable multiple updates to be written as a single batch. As an added benefit, transactions protect your data by ensuring that everything has executed successfully before changes are committed to disk.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint