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 ):
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