Controlling Rowset Size
You can control the rowset size for database queries. The rowset size is defined as the number of rows that the DBMS returns to the client per network transmission.
The ability to change the rowset size allows you to tune PV-WAVE Database Connection to optimize the performance of each query.
Small rowsets:
reduce the amount of temporary memory needed to import a large dataset generated by a query. reduce the number of blocked processes on networks with heavy traffic. increase the time required to complete a query. Large rowsets:
reduce the time required to complete a query. increase the amount of temporary memory required. increase the number of blocked processes.To change the rowset size, modify the PV-WAVE system variable !Dbms_Rowset_Size. For example:
!Dbms_Rowset_Size = 300
The default value of !Dbms_Rowset_Size is 500.
All PV-WAVE Database Connection routines check this variable before accepting data from the DBMS. During the same connection, the rowset size can be changed between one query and another. Changing the rowset size does not affect the total number of rows returned, just the number of network transactions which are required to return all of the rows produced by the query.
