# Fast Data to SQL DB with SQL Bridge Module?

**URL:** <https://forum.inductiveautomation.com/t/fast-data-to-sql-db-with-sql-bridge-module/47597>\
**Category:** General Discussion\
**Tags:** database\
**Created:** [June 9, 2021, 2:35pm UTC](https://forum.inductiveautomation.com/t/fast-data-to-sql-db-with-sql-bridge-module/47597 "2021-06-09T14:35:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![adam.haney](https://avatars.discourse-cdn.com/v4/letter/a/4bbf92/32.png) [@adam.haney](https://forum.inductiveautomation.com/u/adam.haney)\
**Post date:** [June 9, 2021, 2:35pm UTC](https://forum.inductiveautomation.com/t/fast-data-to-sql-db-with-sql-bridge-module/47597/1 "2021-06-09T14:35:47Z")

</div>

We are using Ignition 8.1 as the SCADA to communicate with a TwinCAT runtime and SQL DB.

The feature I am trying to build:  
An Ignition screen that allows users to select a number of variables to begin recording at a 10ms rate. I plan on buffering all signals into a 2D array in the PLC that will have a cumulative record of 1 sec worth of data.

I can constrain the signals the user can choose to record by the Ignition interface, but I will not know the exact variables/data types to be recorded until it is sent to the PLC. From what I know, this variability will cause issues with properly accessing data in the PLC and writing to the SQL DB from the PLC with built-in TwinCAT libraries (unless I use some middleware using a TwinCAT .DLL).

As I understand the SQL Bridge, I would need a transaction group or tag group at a 10ms rate to directly access the variables I want to record if I don’t do buffering. This seems like too fast a rate to do efficiently (but I’m not an SQL expert, or really an expert at anything).

Does anyone have feedback on how to accomplish this feature or a better way to go about this? I appreciate any feedback.

Thank you.  
V/R,  
Adam Haney

---

<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:** [June 9, 2021, 2:53pm UTC](https://forum.inductiveautomation.com/t/fast-data-to-sql-db-with-sql-bridge-module/47597/2 "2021-06-09T14:53:28Z")

</div>

If you are going to buffer 100 samples of each variable, then pause, I would put code in the PLC to present each row to Ignition in a single place. Let Ignition record as fast as you can get it to go, handshaking to move the next row into the single-row recording buffer. I’d script it instead of using a transaction group.

---

<div class="post-metadata">

**Author:** ![adam.haney](https://avatars.discourse-cdn.com/v4/letter/a/4bbf92/32.png) [@adam.haney](https://forum.inductiveautomation.com/u/adam.haney)\
**Post date:** [June 9, 2021, 2:54pm UTC](https://forum.inductiveautomation.com/t/fast-data-to-sql-db-with-sql-bridge-module/47597/3 "2021-06-09T14:54:49Z")

</div>

@pturmel Thank you very much for your feedback. I will attempt this approach.