Make MBS do delete directly in the database - Mendix Forum

Make MBS do delete directly in the database


Make this execute on the database directly, so without first retrieving the objects from db to MBS:

Of course: not if the entity has delete-behavior and/or Before/AfterDelete events.

This will solve a problem that occurs if you want to delete a large amount of objects from you entity.

Currently, this may make the memory of your MBS overflow and your server crash.

Currently ugly workarounds get created, like static SQL-commands or Java-actions, or if you stay in Mendix: loops deleting 1000 objects at the time.




1 answers

yes please! This would really spare a lot of hassle in these cases – – and avoid that you need to explain the out of memory app crash because someone deleted too many objects at once.