# Stored Procedure Vs Direct Mapping with Table when migrate a Legacy System

**URL:** <https://forum.inductiveautomation.com/t/stored-procedure-vs-direct-mapping-with-table-when-migrate-a-legacy-system/39716>\
**Category:** General Discussion\
**Created:** [October 15, 2020, 1:58pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-vs-direct-mapping-with-table-when-migrate-a-legacy-system/39716 "2020-10-15T13:58:12Z")\
**Posts on this page:** 1\
**Showing post:** 6

<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:** [October 16, 2020, 2:12pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-vs-direct-mapping-with-table-when-migrate-a-legacy-system/39716/6 "2020-10-16T14:12:40Z")

</div>

Sounds like you have some scripts to write. And your PLC team has a FIFO to implement. If the machine is cyclic, it should stop when the FIFO is full.

This recent topic might be helpful:

> [@Simple Questions: Writing Tags to SQL](http://forum.inductiveautomation.com/t/simple-questions-writing-tags-to-sql/39269):
>
> I need to write values to from the plc to my db a bit faster and with more handshaking than I get with the SQL Bridge. I want some advice so I don’t get started wrong on this. I’ll have a bool tag in the PLC to say I’m ready to send the data. Should I just use memory tags for handshaking and read/write them from my script to control the flow? Are there pros/cons to having the script be a tag-event script that triggers when the PLC is ready vs. it being a GW script that monitors the statu…

I have similar advice scattered through the forum archives.

---

_[View the full topic](https://forum.inductiveautomation.com/t/stored-procedure-vs-direct-mapping-with-table-when-migrate-a-legacy-system/39716)._
