Advanced topics on view objects
In a view object, you will have the custom logic to work on SQL queries and the data that is displayed in the UI layer. The following are some of the advanced concepts for view objects:
Tuning: View object tuning plays an important role in the performance of an application. Some of the common tuning concepts are discussed here in this section.
MaxFetchSize:MaxFetchSizeis the maximum number of rows fetched from a database for the current view object.-1will retrieve an unlimited number of rows or all the rows returned from a query. The value0will cause no query execution and no rows will be returned.FetchSize: This is the number of rows that is returned on a single database round trip. This setting will determine how many rows will be returned for a particular view object at runtime on a single query.FetchMode: This is the mode that controls how the rows are retrieved in a JDBC result set. Some of the modes allowed for this function are as follows:...
