Thanks Colby
well for groups which are for recording data I will have to come up with some similar scheme as i mentioned before, However, could be please answer my following question?
“am I to understand that my stored procedure groups which do not have any SQL Action items will not be cached even after some time, if the database is down?”
before I start the activity of moving the 1000s of groups from RSSQL to FactorySQL or even ignition, I would like this clarified so I can implement the best method from the beginning