# Performance/Large Data Sets

## Maximum Items

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.&#x20;

## Dynamic Loading

{% hint style="warning" %}
Dynamic Loading is required to handle more than 500 tasks in a single gantt chart.
{% endhint %}

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).&#x20;

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.

{% hint style="info" %}
Note that when a task is expanded dynamically, all of its subtasks will be displayed - regardless of any views or filters applied.
{% endhint %}

For example, under Filtering, set the **Type** to only retrieve **Projects**:

![](https://2421994811-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLN8Zmi11JUWQyHqV0fE%2Fuploads%2F5bqzeFYFdmOhcgmFnkWE%2Fimage.png?alt=media\&token=8429b143-95f7-47e0-90b9-da289fd52806)

Furthermore, set **Expand** on load to **Collapsed**, and **Dynamic loading** to **On:**

![](https://2421994811-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLN8Zmi11JUWQyHqV0fE%2Fuploads%2FSXpMZ1SrKINXuCZwkTvj%2Fimage.png?alt=media\&token=ed5032c3-2e53-4cd4-86db-ec3ec3f6d8b5)

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:

![](https://2421994811-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLN8Zmi11JUWQyHqV0fE%2Fuploads%2F6us19hcFimzwzJ9yGA7O%2Fimage.png?alt=media\&token=d0f0c9ff-04b7-4915-8596-6dbccdafa369)

Any number of fields can be selected.

This is set within **Filtering > End-user filterable fields**:

![](https://2421994811-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLN8Zmi11JUWQyHqV0fE%2Fuploads%2FUFDpRfm6gBSBakrzD4Sr%2Fimage.png?alt=media\&token=220a27ef-07d0-4066-9e72-5ad44d48edc8)

## 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.&#x20;

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.&#x20;

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:

![](https://2421994811-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLN8Zmi11JUWQyHqV0fE%2Fuploads%2FvFvCPssiFN3vr8vwEjGt%2Fimage.png?alt=media\&token=6dd68685-11e0-4bc3-b9af-4d96c7fcc6fb)

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:

![](https://2421994811-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLN8Zmi11JUWQyHqV0fE%2Fuploads%2FnotJZ2CY9TlnBTUAWJ4U%2Fimage.png?alt=media\&token=c0f5efc7-007c-4786-b303-3cbfd253db42)&#x20;



##

&#x20;





