System resources are getting filled so much with meta data
0
Hi Everyone We have a application which will be used to perform simple operation tasks. . We noticed that disk resources have been steadily filling up over time. After analysizing the full snap shot and database, we found that there are tables related to Workflow Engine and ProcessQueue (tablename: system$processedqueuetask), which are getting filled with millions of records which are not required to maintain in our application. It is causing too much issue on system performace as well. Is there a way to clean up all these meta data in Mendix? Will deleting these records from the database be enough to free up disk space, or is there anything else we need to do? Thanks and Regards Manjunatha
asked
Manjunatha Koni Gururaja
1 answers
0
This table is probably filled with your scheduled events that are running in the taskqueue and these need to be cleanup.
You can write a microflow that retrieves the records and deltes them (make sure to retrieve the data in batches for performance) and trigger this microflow with a scheduled event once a day for example.