Performance tuning: number of rows per page

Edit online

Adjusting IZSME® settings can improve performance, when reading large tables. The maxRowsInPageRequest setting lets you paginate the results of a query for faster response.

When IZSME is reading a large table, a user may experience slow performance because of the large number of rows displayed per page. To reduce the delay, you can limit the number of rows that are displayed at any one time, by paginating the display. When IZSME displays the results of a query, the status line at the bottom of the panel will indicate how many lines are displayed per page, and how may pages the entire search set contains. For example, it might say Items per page 200 and 1 of 13 pages, with an arrow button to retrieve the next 200 results.

Changing the default page size

The default setting is 200 items per page. If you want to change the setting, ask your system administrator to do so, following these instructions.

The default setting of 200 rows per page overrides the number of rows specified in the view definition in Tivoli Enterprise Portal. Because IZSME sorting and filtering is done on the server, large page sizes are much less necessary than in the Tivoli Enterprise Portal, where sorting and filtering are performed in the client, which can make it hard to find the data you need when the page size is smaller than the result set.

You can change this value by editing the pluginConfig.json file, which resides in <IZSME_HOME>/ctds/teps_utils/config. The file looks like this:
{
  "javaListenerPort": "20202",
  "javaVMArguments": [],
  "classPath": "../lib/jar/*",
  "cache": {
    "navigatorTree": {
      "cacheTimeoutSec": 300,
      "cacheCount": 15
    },
    "physicalTree": {
      "cacheTimeoutSec": 86400,
      "cacheCount": 15
    },
    "customTree": {
      "cacheTimeoutSec": 86400,
      "cacheCount": 15
    },
    "situationTemplates": {
      "validFor": 300000
    }
  },
  "memoryUsageDumpIntervalSec": 900,
  "resourceUsageDumpIntervalSec": 3600,
  "maxRowsInPageRequest": 200
}

The maxRowsInPageRequest setting specifies the maximum number of rows to be displayed per page. A value greater than zero (0) will limit the maximum displayed rows. If you want to display the entire result set in one page instead of limiting the number of rows displayed, specify a value of -1.