# ClickToChart Slow to Load

**URL:** <https://forum.inductiveautomation.com/t/clicktochart-slow-to-load/1572>\
**Category:** Archived Topics\
**Created:** [February 24, 2010, 5:00pm UTC](https://forum.inductiveautomation.com/t/clicktochart-slow-to-load/1572 "2010-02-24T17:00:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jonathan](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\
**Post date:** [February 24, 2010, 5:00pm UTC](https://forum.inductiveautomation.com/t/clicktochart-slow-to-load/1572/1 "2010-02-24T17:00:22Z")

</div>

I have implemented the ClickToChart application for many of the devices at our plant. I am having issues with one area where we have been collecting data for many years. There are probably about 3 million rows in the table for the device.

When I try pulling up any of the device measurements into the ClickToChart it will say loading for several minutes in the bottom right and eventually time out. Sometimes it will pull up information into the chart, but never in real-time only historical.

I have put a where clause on the pen

```auto
t_stamp > DATEADD(week, - 1, GETDATE())
```

with no change. What can I do to alleviate the problem?

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [February 24, 2010, 5:49pm UTC](https://forum.inductiveautomation.com/t/clicktochart-slow-to-load/1572/2 "2010-02-24T17:49:01Z")

</div>

This sounds like it might just be caused by a missing index. Are all of the columns you’re using in the WHERE clause (by default, just the t\_stamp column) indexed?

---

<div class="post-metadata">

**Author:** ![Jonathan](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\
**Post date:** [February 24, 2010, 5:59pm UTC](https://forum.inductiveautomation.com/t/clicktochart-slow-to-load/1572/3 "2010-02-24T17:59:48Z")

</div>

it looks like the only index is on column tblFiltration\_ndx

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [February 24, 2010, 6:11pm UTC](https://forum.inductiveautomation.com/t/clicktochart-slow-to-load/1572/4 "2010-02-24T18:11:39Z")

</div>

Oh yeah, add a t\_stamp index and it should be dramatically faster.