# Store & Forward Data Cache question

**URL:** <https://forum.inductiveautomation.com/t/store-forward-data-cache-question/93656>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [July 24, 2024, 10:27am UTC](https://forum.inductiveautomation.com/t/store-forward-data-cache-question/93656 "2024-07-24T10:27:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Samuel\_Sueur](https://avatars.discourse-cdn.com/v4/letter/s/e36b37/32.png) [@Samuel\_Sueur](https://forum.inductiveautomation.com/u/Samuel_Sueur)\
**Post date:** [July 24, 2024, 10:27am UTC](https://forum.inductiveautomation.com/t/store-forward-data-cache-question/93656/1 "2024-07-24T10:27:26Z")

</div>

Hi all,

I have a question regarding the Local Cache for the Store & Forward.

It is my understanding it is best that, when the DB is up and everything is running smoothly, the local data cache should never be used as this can be an expensive operation. From what I understand, it should only be useful when the DB is down, and the data can't go anywhere so it is stored in the local disk cache.

I've tinkered around with the local cache settings but I can never get it to go Idle, it still stores data from time to time to the local cache before being forwarded to the DB.

This is a rather large project so there are usually around ~400 data points logged each second.

Knowing this, below are my store and forward settings:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/6/963049dd70c277df0405ff3b5afa9747c183d8f2.jpeg)

Does anyone see something that does not make sense considering the inflow of data is around ~400 datapoints per sec?

Thanks all

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 24, 2024, 12:31pm UTC](https://forum.inductiveautomation.com/t/store-forward-data-cache-question/93656/2 "2024-07-24T12:31:14Z")

</div>

Sounds like your database is having occasional hiccups. You should study your database logs.

Are you using the same database for large history queries for charting or data analysis? Those can disrupt insert operations. (A separate read-only replica database is the solution to that problem.)

---

<div class="post-metadata">

**Author:** ![Samuel\_Sueur](https://avatars.discourse-cdn.com/v4/letter/s/e36b37/32.png) [@Samuel\_Sueur](https://forum.inductiveautomation.com/u/Samuel_Sueur)\
**Post date:** [July 24, 2024, 12:55pm UTC](https://forum.inductiveautomation.com/t/store-forward-data-cache-question/93656/3 "2024-07-24T12:55:47Z")

</div>

Thanks Phil,

Yes, we use the same DB for both charting and logging data. This might be the issue, and also part of the reason why we're having trouble displaying big chunks of history in charts.

We'll look into creating a separate read-only replica database, thanks a lot !