Performance/Large Data Sets
Last updated
Last updated
By default, the maximum number of items that can be loaded into a chart is 500. This is a figure based on the average browser render times of end users. You can increased this value under Settings > Performance > Max loadable items, but we do not recommend you do so.
In order to handle large lists containing more than 500 items, and indeed up to thousands (or even millions!) of items, you should configure Dynamic Loading as described below.
Dynamic Loading is required to handle more than 500 tasks in a single gantt chart.
To maintain good rendering performance, when dealing with large data sets, it is recommended to organise tasks into a hierarchy (e.g. Project > Task > Subtask).
In addition, it is recommended to load the tasks using either an initial filter or view such that only the top-level tasks are loaded initially, and subtasks are retrieved on-expand.
Note that when a task is expanded dynamically, all of its subtasks will be displayed - regardless of any views or filters applied.
For example, under Filtering, set the Type to only retrieve Projects:
Furthermore, set Expand on load to Collapsed, and Dynamic loading to On:
Only projects will be initially loaded into the chart, and their tasks will only be loaded when expanded by a user.
Fields can be configured to appear in the command bar for end-users to filter on:
Any number of fields can be selected.
This is set within Filtering > End-user filterable fields:
In order to create multiple separate groups of tasks, you may wish to create views. A view is essentially a pre-configured query on to your list of projects/tasks.
For example, let's say you want to create views such as 'My Tasks', 'Overdue Tasks', or 'Tasks Due Next Week' - these can be configured in the SharePoint List by navigating to List Settings > Views.
Once a view is created, it can be configured in the Gantt web part to be a default view, and multiple views can be nominated as user-selectable:
In this case, the Gantt chart is rendered with tasks from 'My Tasks'. The two views - My Tasks and All Items, are available for the end user to switch between:
