# Problems with Database connections Store/Forward Throughput

**URL:** <https://forum.inductiveautomation.com/t/problems-with-database-connections-store-forward-throughput/78240>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [August 22, 2023, 3:33pm UTC](https://forum.inductiveautomation.com/t/problems-with-database-connections-store-forward-throughput/78240 "2023-08-22T15:33:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Miguel\_Cimildoro](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@Miguel\_Cimildoro](https://forum.inductiveautomation.com/u/Miguel_Cimildoro)\
**Post date:** [August 22, 2023, 3:33pm UTC](https://forum.inductiveautomation.com/t/problems-with-database-connections-store-forward-throughput/78240/1 "2023-08-22T15:33:18Z")

</div>

I have a problem and it really urges me, I have a series of connected databases (everything works fine) but when I enable the Alarm\_Journal table everything crashes.

I am thinking (debugging a little) that the (Store Throughput) is very high and when I enable the table the (Forward Throughput) sends a grant amount of datapoints and is the reason why the whole database falls, is it normal that amount of datapoints?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/2/82a1516bcbec004994c8225e253cd201ec0f6ad3.png)

Any recommendations or solutions regarding this?

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [August 22, 2023, 4:32pm UTC](https://forum.inductiveautomation.com/t/problems-with-database-connections-store-forward-throughput/78240/2 "2023-08-22T16:32:29Z")

</div>

Do you see anything in the gateway logs? Those `Unavailable` line items under Activity - if you hover your mouse over them you should get some information - what does it say?

---

<div class="post-metadata">

**Author:** ![Miguel\_Cimildoro](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@Miguel\_Cimildoro](https://forum.inductiveautomation.com/u/Miguel_Cimildoro)\
**Post date:** [August 22, 2023, 4:41pm UTC](https://forum.inductiveautomation.com/t/problems-with-database-connections-store-forward-throughput/78240/3 "2023-08-22T16:41:46Z")

</div>

you mean this?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/3/135ba1cc2c048ddb12d9d89b058034bf05a2b233.png)

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [August 23, 2023, 12:00am UTC](https://forum.inductiveautomation.com/t/problems-with-database-connections-store-forward-throughput/78240/4 "2023-08-23T00:00:42Z")

</div>

Here is a similar problem with solution from the Cirrus Link Forum.

> **[MQTT Engine - JsonPayloadHandler NULL Values](https://forum.cirrus-link.com/t/mqtt-engine-jsonpayloadhandler-null-values/317?u=justinedwards.jle)**
>
> Hi. I was configuring a new connection within MQTT Engine (Version 4.0.8) along with a custom namespace that had the option \[Parse payload as JSON\] enabled. When I do, I receive error logs from the JsonPayloadHandler logger that contains “JSON...

---

<div class="post-metadata">

**Author:** ![Miguel\_Cimildoro](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@Miguel\_Cimildoro](https://forum.inductiveautomation.com/u/Miguel_Cimildoro)\
**Post date:** [August 23, 2023, 7:30am UTC](https://forum.inductiveautomation.com/t/problems-with-database-connections-store-forward-throughput/78240/5 "2023-08-23T07:30:59Z")

</div>

I think it's not what I'm looking for, the question is where do these datasets come from? and is there any way to reduce that amount? because I think that's the reason why my database is crashing.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/8/98b55b7da56098777ebdd5de0ce86f7103ea857b.png)
