I have a SQL table with datetimes and values, I need it so when that date time is passed the tag values will be updated to the corresponding values from the table. What is the best way to approach this without needing to query the database at a high rate.
How often does the SQL Table get updated? One approach would be to use a dataset tag to store the query results, with whatever scripts or transaction groups looking up data from the tag.