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

[pturmel]

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

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.