Performance/Large Data Sets

Dynamic Loading

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.

End-user filter fields

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:

SharePoint Views

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: