Hello,
I have a custom table in Creatio that stores integration logs for all of our integrations. Over time, the volume of records in this table has grown significantly, and we are now starting to notice an impact on the performance of operations involving this table.
I would like to reduce the size of the active table while still retaining older log records for historical reference and troubleshooting purposes.
Does Creatio provide a built-in mechanism for archiving data from custom tables, or how could this archiving be achieved.
Thank you
Like
They don't as far as I've found with a few cases of wanting archiving unfortunately.
I've always had to do some workaround such as copying the data using automated SQL scripts into an exact copy of the object for archiving purposes (I have done this by creating a new Object and setting its parent to the Object that needs archiving). This has some downsides that any changes to the regular Object won't apply to the archive Object until you re-publish the archive Object, so something to look out for.
Another issue to watch out for is how the archived data references other data, e.g. if you have parent-child relationships and you are archiving by copying exactly using SQL, the archived record would still be pointing at a "live" record rather than an archived one. Again, custom solutions are required for this.
Overall it's quite a pain, and plenty of issues can arise. It would be great if there were a built in way of doing so.