Store & Forward Data Cache question

Ignition
1

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
image1303×915 158 KB

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

Thanks all

2

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.)

1 Like
3

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 !