This section describes the fetching process that WebClient implements to retrieve database records.
This section describes how the WebClient fetching process differs from a typical Client/Server application.
Additionally, in order to implement the smooth scrolling feature of the WebClient grids, after the page is loaded and displayed there is an extra blockfetch call to retrieve additional data so that the user scrolling through the page can do it smoothly without the need to stop to get additional data.
Since page sizes other that 64 are not supported, the WebClient developer may need to use different techniques to achieve optimal performance.
There are 3 possible approaches to improve BlockFetch performance:
- Improve the fetching process. On many occasions the implementation of non-standard page sizes is done to improve performance of inefficient fetching processes that perform row-by-row calculation and/or processing. Such inefficient processes can generally be improved by creating custom SQL queries that execute on the server and increase the overall process performance.
- Modify the C/S application’s fetch process to implement the 64-record blockfetch/page size.
- Create a layer for the fetching process based on the C/S one that implements the 64-record blockfetch/page size