When a Jedox Web Spreadsheet is being loaded in the browser, or when a user scrolls through a spreadsheet, Jedox Web is aware of the viewport (i.e., the area that is visible in the user’s browser window), and fetches data only for that viewport, plus a buffer space. This reduces the amount of data that needs to be transferred from the Jedox Web server to the browser. On the other hand, this also implies that when a user navigates/scrolls through the spreadsheet, at some point additional data needs to be fetched. This can cause a very short pause in the scrolling mechanism.
You can increase the amount of data that is fetched both during initial load of a spreadsheet and when scrolling in the sheet. To do so, open the panel Jedox Web Administration and navigate to Settings–Spreadsheet–Cache. The following two settings control the cache behavior:
- preload_coef: controls the amount of data fetched during initial load of spreadsheet
- readahead_coef: controls the amount of data that appears when scrolling
If undefined, the default value for both settings is 2.
Note that while increasing these settings may prevent data fetching while scrolling in a spreadsheet, it may also increase the time required for initial load of the sheet, as more data has to be fetched upfront.