Gateway - How to display the size of dataviews on a gateway?
This information can be obtained from the gateway by using the Gateway-SQL plugin. The query works by counting the total number of table cells (excluding the headlines and row name column) in each dataveiw. An example of the dataview is listed below. The xml of the sampler can be downloaded for your configuration.
Depending on the estate of your gateway, the sampler may be expensive in terms of performance and may take some time to run.
Due to the above reason, the sampler is configured on purpose NOT to sample on startup and does not run on its own. It has a 0 sampling interval. As a result, you will see 0 rows, Manual sampling in the dataview when the sampler is initialized.
To run the sampler manually, click on the Sample now or refresh icon in the dataview.
For more information, see the Gateway-SQL section on the Gateway Plug-Ins documentation. The SQL statements are based on SQLite.