Recommendations to configure data source-based widgets

In order to best configure and use data source-based widgets in your widget homepage, beqom advocates to follow several recommendations. As Small Table Widget, Large Table Widget and Pie Chart widgets rely on custom data sources, the risk of performance issues is increased.

To prevent any performance risks, beqom recommends to perform the following actions:

• Whenever possible, use prepopulated tables with preaggregated values (with fewer number of records) for your data sources instead of using views.

• Avoid performing SQL activities (such as update or insert transactions) on the data sources currently in use during working hours. Such activities may lock the data, preventing widgets from retrieving information when users log in to the homepage. Mind the following points to better follow the data update activity:

  • The Refresh Date option is intended to inform users about the last refresh of the data.

  • Consider configuring the "deep link" option to allow users to access more up-to-date information, such as data grids , process grids, or analysis reports.

• Create indexes for the data source tables based on the filtering options used in the widgets (idUser, idProfile or both).

• Ensure that the indexes are regularly rebuilt, and statistics are updated for the data source tables used by the widgets.

• Limit the number of records in the homepage table widgets per user as much as possible. Additionally, provide a deep link in case users wish to access the full dataset, which can be directed to process grids, data grids or reports.