Many tags to log but few will be changing

Archived Topics
2

Hi Tim,

Looking at FSQL, it looks like the “async update” checkbox on the group trigger tab should be what you are looking for.

As for the data duplication, I would highly recommend designing a fully normalized database schema ahead of time for such a large task. It might be somewhat of a p.i.t.a. now, but you’ll be glad you did later on if you have to support it. There are many database books which teach you how to do this, but it should be something similar to this (off the top of my head, so bear with me :wink:):

Plants

PlantID (PK)
PlantName
etc.

Pumps

PumpID (PK)
PumpName
etc.

PlantPumps

PlantID (PK, FK)
PumpID (PK, FK)

PumpLogs

PumpID (PK, FK)
LogDate (PK)
PumpSpeed
etc

Hope that helps.

–HandledException