# Ignition Realtime Data Storage

**URL:** <https://forum.inductiveautomation.com/t/ignition-realtime-data-storage/55277>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [January 21, 2022, 10:34pm UTC](https://forum.inductiveautomation.com/t/ignition-realtime-data-storage/55277 "2022-01-21T22:34:23Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![pridesleap](https://avatars.discourse-cdn.com/v4/letter/p/f4b2a3/32.png) [@pridesleap](https://forum.inductiveautomation.com/u/pridesleap)\
**Post date:** [January 21, 2022, 10:34pm UTC](https://forum.inductiveautomation.com/t/ignition-realtime-data-storage/55277/1 "2022-01-21T22:34:24Z")

</div>

Where does Ignition store Realtime or short term data? I know it will store data long term in a DB but how does it handle short term or realtime data? Does it send realtime data directly to the DB or is there a buffer or built in DB for this purpose?

---

<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:** [January 21, 2022, 11:12pm UTC](https://forum.inductiveautomation.com/t/ignition-realtime-data-storage/55277/2 "2022-01-21T23:12:48Z")

</div>

Current values are in memory. That is the “tag”. Everything else goes to the DB. When there are connection problems, data may be buffered in the store and forward system. The S&F does not contribute to trend graphics, though, last I knew.

---

<div class="post-metadata">

**Author:** ![pridesleap](https://avatars.discourse-cdn.com/v4/letter/p/f4b2a3/32.png) [@pridesleap](https://forum.inductiveautomation.com/u/pridesleap)\
**Post date:** [January 21, 2022, 11:17pm UTC](https://forum.inductiveautomation.com/t/ignition-realtime-data-storage/55277/3 "2022-01-21T23:17:10Z")

</div>

Thank you. I just wanted to make sure that the short term buffer and S&F wasn’t relying on some internal DB structure to execute.

---

<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:** [January 21, 2022, 11:18pm UTC](https://forum.inductiveautomation.com/t/ignition-realtime-data-storage/55277/4 "2022-01-21T23:18:59Z")

</div>

Store and forward uses RAM for a small buffer, and gateway-local files for a somewhat larger buffer. Precise behavior is an undocumented implementation detail, but is independent of the DB connection itself.

---

<div class="post-metadata">

**Author:** ![pridesleap](https://avatars.discourse-cdn.com/v4/letter/p/f4b2a3/32.png) [@pridesleap](https://forum.inductiveautomation.com/u/pridesleap)\
**Post date:** [January 21, 2022, 11:22pm UTC](https://forum.inductiveautomation.com/t/ignition-realtime-data-storage/55277/5 "2022-01-21T23:22:04Z")

</div>

> [@pturmel](#):
>
> Precise behavior is an undocumented implementation detail, but is independent of the DB connection itself.

Fair enough.

---

<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:** [January 21, 2022, 11:25pm UTC](https://forum.inductiveautomation.com/t/ignition-realtime-data-storage/55277/6 "2022-01-21T23:25:39Z")

</div>

Also note that the standard tag historian (“tall” tables) always uses the store and forward system. The SQL Bridge module’s Transaction Groups (“wide” tables) are configurable per group whether to route through the S&F system. Scripting can submit database inserts directly or through the S&F system at the programmer’s discretion.

---

<div class="post-metadata">

**Author:** ![pridesleap](https://avatars.discourse-cdn.com/v4/letter/p/f4b2a3/32.png) [@pridesleap](https://forum.inductiveautomation.com/u/pridesleap)\
**Post date:** [January 22, 2022, 12:48am UTC](https://forum.inductiveautomation.com/t/ignition-realtime-data-storage/55277/7 "2022-01-22T00:48:39Z")

</div>

Perfect. Thank you for that as well.
