# History Slowly

**URL:** <https://forum.inductiveautomation.com/t/history-slowly/12558>\
**Category:** Ignition\
**Created:** [January 13, 2017, 1:54pm UTC](https://forum.inductiveautomation.com/t/history-slowly/12558 "2017-01-13T13:54:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![folgore](https://avatars.discourse-cdn.com/v4/letter/f/edb3f5/32.png) [@folgore](https://forum.inductiveautomation.com/u/folgore)\
**Post date:** [January 13, 2017, 1:54pm UTC](https://forum.inductiveautomation.com/t/history-slowly/12558/1 "2017-01-13T13:54:11Z")

</div>

Hello, I have a bad performance in a to read a history tag only when the start date is older then 2 weeks (I have a new table even 2 weeks) and the same period (24 hours).

For example if I select yesterday in 1 second I have my dataset completed, but if I select one month ago it takes 30 seconds and more.

Is possible to improve the performance?

Thank’s

---

<div class="post-metadata">

**Author:** ![Aaron.Huffman](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@Aaron.Huffman](https://forum.inductiveautomation.com/u/Aaron.Huffman)\
**Post date:** [February 11, 2017, 12:52am UTC](https://forum.inductiveautomation.com/t/history-slowly/12558/2 "2017-02-11T00:52:14Z")

</div>

It might be worth looking into the underlying cause of the slowness, but I suspect the queries themselves are taking a while to run. You can monitor this from “Status \> Databases” on your gateway webpage.

Is anything else hitting your database server, or is Ignition hitting it particularly hard?

You could try the standard sort of options like pruning data, using preprocessed partitions, etc. Out of curiosity, how many rows are in your sqlth\_sce table?