Updating Data

This section provides general guidelines to help you to optimize system performance when updating data in databases.

Using the Disconnected DataSet

Keep result sets small. The full result set must be retrieved from the server before the DataSet is populated. The DataSet must then be converted to XML and processed. The full result set is stored on the client.

Synchronizing Changes Back to the Data Source

You must build the logic into the PsqlDataAdapter for synchronizing the changes back to the data source. For Pervasive.SQL, you use the primary key, as shown in the following example.

string updateSQL As String = "UPDATE emp SET sal = ?, job 
= ?" + " = WHERE empno = ?";