Page Size for views explained

Created 2003-07-02 by Wajih-ur-Rehman

What is page size for a view and what is the importance of it?

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, 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 of less 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 things and set the page size accordingly.

Page size is also important for Auto Refresh Feature. Read the following link to know about it:

http://www.monitorware.com/en/FAQ/Problems-With-AutoRefresh.asp