On a request from a customer, I want to eliminate a bunch of data entry via form into an existing database.
The database structure uses similarly structured tables kept in 6 tables separated based on frequency that is recorded. Ex. Table 1 has 1 minute recorders, Table 2 has 5 minute... 15m, 30m, 1h, 4h.
I believe transactional are the right method to get this moving, but I haven't had a project using them yet and would appreciate advice on how to split things up. I have about 30 tags that I need to log to each of these tables. I've got a test group that accomplishes a single record log well.
Is there a good way to scale this up without making 30 tags * 6 tables = 180 historical transactional groups? Seems like I could make one group for each recording frequency, but am having difficulty imagining how that would work.