[Webinar] OO Database purging recording available
I will post below the final questions from the webinar together with their answer:
Q: How about OO installer creates vendor specific purge procedures in the DB? Then the flows /API could call those procedures to take advantage of native performance gains
A: We are looking into both possibilities of improving the APIs related to purging as well as the overall experience, however this particular option at this time is not implemented due to in part the limited availability of scripts, scenarios where database access from OO is severely limited (no DDL scenarios) and concerns regarding safeguards which we may or may not be able to implement (to name a few). The installer needs to work under a “one size fits all” mode and as such before we add any new option to the installer we first need to ensure that the new option will respect this principle.
Q: It would be nice if the flows could report the total rows deleted in the DB in addition to the records “Removed xxx records using yyy rows”
A: We have an enhancement request to improve the data reporting of the flows in the system and we will look at both flow and api capabilities to improve this when the enhancement request will be handled.
Q: Is there any issue with simply scheduling the desired purge flows at the desired retention to run daily? The db size should never get out of hand..
A: There is no issue with this whatsoever, in fact on certain internal environments we actually schedule the purge execution summary to run several times per day with the given retention period and as such we keep the data that needs to be deleted on every purge execution to a minimal. If you plan to do this just make sure to schedule the flow in accordance to the retention period type you want (as described in the webinar) and according to the activity of the central in order to schedule the flow at a relative low activity period.
Thank you for attending,