The attached test creates 1000 large objects and then attempts to delete them all in one go using a DELETE statement. I'm trying to run with -Xmx512m but the test runs out of memory during the delete.
The attachment also contains an update test which has similar memory problems. I'm running both tests with the default objectdb.conf.
In general is an UPDATE/DELETE statement the most efficient way to update/remove a large number of objects?
I've had success with the "drop" keyword in the connection string in other circumstances but I need a method that can work in both embedded and server based databases (in server mode the database is locked so drop can't be used).
The only method I've found which works consistently is to load and remove objects (one by one or small batches) but this is painfully slow when there is a high number of large objects.