Mendix does not handle 40K+ objects all at once well (with normal delete object(s) action). Reason usually is that the app runs out of memory (as all changes could be rolled back at some point in time before you finish the whole delete action). So you need to work around the huge set of data to process.
You can either:
- do a looped delete (retrieve max 10000 items, delete; retrieve the next batch until none found); take care with transactions, as they need to be closed off during those batches (otherwise it’ll crash as well).
- do a queued task delete (retrieve x items, delete; handle next queued batch;
- do a delete by sql query inside a java action (those are usually very fast)
Hi,
Try batches flow to delete the large volume of records
Hope it helps!!!
Hi Pragya ,
I suggest you put a debugger inside Microflow and follow the steps one by one . Also, can you explain more specifically what you mean by crash?
Regards
Ridvan