Figure 1: Common View Settings - General Tab
Page Size: Page size is the maximum number of records that a user can see on one page in the data grid. If the number of records brought by the query is greater than the page size for that view, user has the option of pressing the "Next" button (will be explained in the coming sections) to go to the next page. In short: at one time, the user will not be able to see records greater than "Page Size" specified in this tab.
A paging algorithm has been implemented in MonitorWare Console to improve efficiency. Had there been no paging algorithm, then the data grid had to display ALL the records that are returned from the database (imagine 1 million records being returned) and the user had to wait for a very long interval of time to see the results. The paging algorithm only brings those many records at one time that are specified in the page size. So greater the page size, the more will be the time for each page to be displayed because of more number of records that are to be brought from the database but the total number of pages would be less. On the other hand, if the page size is kept small, then less time will be taken for each page to be displayed because a lower number of records are to be brought from the database but this will increase the total number of pages. Depending upon your requirements, you should make some compromise between these two options and set the page size accordingly.
Data Sort Order: This is the sort order according to which the data will be brought in the data grid. Currently this sorting is applied on the ID column.