# Application Chart widget slow when using All Computers

> Fix a slow Application Chart widget when All Locations includes unmapped subnets, caused by a missing database index.

Source: https://docs.capaone.com/performanceguard/troubleshooting/application-chart-widget-slow-when-using-all-computers/  
Product: PerformanceGuard — a separate CapaSystems product; do not apply this page to any other.

## **Problem**

Created an All Locations and added all unmapped subnets, now selecting All Locations instead of All Computers, the widget refresh rate is very slow.

## **Cause**

There is missing an index on the table holding the data needed.

## **Solution/Workaround**

Add the two indexes below. *Be aware that you will see a relatively large increase in the disk space used to hold the tables*.

:::note
```
CREATE NONCLUSTERED INDEX [agent_traffic_aggr_idx3]  
ON [pguard].[agent_traffic_aggr_monitored] ([protocol_id],[ip_address],[port],[timestamp])  
INCLUDE ([h1],[h10],[h2],[h3],[h4],[h5],[h6],[h7],[h8],[h9],[num_clients],[received_bytes],[received_trains],[sent_bytes],[sent_trains],[total_response_time],[process_name]) ON pguard_indx_big  
GO  
  
CREATE NONCLUSTERED INDEX [agent_traffic_aggr_unmonitored_idx3]  
ON [pguard].[agent_traffic_aggr_unmonitored] ([group_id],[protocol_id],[port],[timestamp])  
INCLUDE ([h1],[h10],[h2],[h3],[h4],[h5],[h6],[h7],[h8],[h9],[num_clients],[received_bytes],[received_trains],[sent_bytes],[sent_trains],[total_response_time],[process_name]) ON pguard_indx_big  
GO
```
:::

## Related articles

- Page:

  [Application Chart widget slow when using All Computers](/performanceguard/knowledge-base/application-chart-widget-slow-when-using-all-computers/)