Is there any reason why a retrieve with an offset higher than 300.000 would crash the system? I have a MF that iterates over 800.000 records in batches of 250. After every 100.000 I perform an EndTransaction. when I reach 300.000 (or about) the application shuts down without any error. Initially I first thought it was because of an error in the MF but when I start the MF with 300.000 offset it goes down immediately
Willem de Vriend
I think you’re doing a batch process for your iteration process? But this amount of objects could be too much for Mendix.
I think what you can do is to try to run the process in multiple steps by reducing the amount of handled objects.
What you also could do is to use the Process Queue Module and then run a batch process to create a amount of queued actions and retrieve in your queued action the related objects. So finally you will reduce the amount of objects handled in a single, independent transaction.
I know this module is good performing large import, maybe you find a hint here…