Tip: Reduce round trips to the database server

One of the most important determinants of application performance is the number of database server round trips required to process any activity. Round trips to the server are more important than the amount of data being passed to the server. In many cases, the number of round trips is more important than the actual amount of processing on the server. Because of this consideration, Windows client supports these options:

  • Windows client allows the validation of input values and the retrieval of related values to be performed in a single call to the server.
  • Windows client allows you to bypass validations when the component's value is selected from a list.
  • IDO records (rows) in the primary collection and in each subcollection are saved in one network round trip.

You should always attempt to eliminate round trips to the server whenever possible. For instance, if you are performing several validations for a component on the server, you can improve performance by writing a stored procedure that performs all of the validations. Then, you use a single validator in WinStudio to call this stored procedure.