# Slow loading of Historical Easy Chart

**URL:** <https://forum.inductiveautomation.com/t/slow-loading-of-historical-easy-chart/53120>\
**Category:** Ignition\
**Tags:** ignition81, vision\
**Created:** [November 16, 2021, 10:40am UTC](https://forum.inductiveautomation.com/t/slow-loading-of-historical-easy-chart/53120 "2021-11-16T10:40:14Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![karnthaler](https://avatars.discourse-cdn.com/v4/letter/k/bbce88/32.png) [@karnthaler](https://forum.inductiveautomation.com/u/karnthaler)\
**Post date:** [November 16, 2021, 10:40am UTC](https://forum.inductiveautomation.com/t/slow-loading-of-historical-easy-chart/53120/1 "2021-11-16T10:40:14Z")

</div>

Hi all,

since our update from 7.9 to 8.1 I have a really big problem with performance regarding easy\_chart components. I have a standard timeseries chart, the SQL Query for which takes approx. 200ms and the easy\_chart in realtime configuration takes not much longer then that to load all the data. The chart in historical configuration however takes over 45 seconds to load the same data as the first 2 mentioned options.

Here you can see the entry from the Longest Recent Queries page:

```auto
SELECT 
t_stamp, TemperaturOberflaeche, WalzenspaltMittelwert, DruckLinks, DruckRechts, GeschwindigkeitUnterwalze, WalzenspaltLinks, WalzenspaltRechts, iif(Betriebszustand=5,1,0), iif(Betriebszustand=3,1,0), iif(Betriebszustand=2,1,0), iif(Betriebszustand=4,1,0), iif((Betriebszustand=0 or Betriebszustand=1),1,0) 
FROM 
Kalander5VisuTrend 
WHERE 
t_stamp &gt;= ? AND t_stamp &lt;= ? ORDER BY t_stamp

```

Does anyone have an idea why there could be such a massive difference in loading times?

I’m running version 8.1.7 on Windows Server 2016 64-Bit and Microsoft SQL Server 2017

My CPU usage normally is between 1 and 5% and my RAM usage is about a fourth to a third of the total allocated space.

Thanks in advance!