I am working on converting an existing reporting program that is using Wonderware and MSAcess. Currently WW is writing rows to a table in the database and there are a few forms with querys for shift reports. We are going to convert this Ignition and MySql.
Right now data is logged every minute. The shift reports are based hourly. Would it be better to keep this same practice of logging every minute and then building another table with hourly averages and totals for the report? Or would it be better to just skip that step and just have Ignition calculate the values every hour and only log that value?
Just looking for suggestions on how to go about this project.