In this context, you have a number of potential options:
- Deleting a record using a conditional approach. Refer to the Batch operation for further details. More information can be found at this link: https://docs.appery.io/reference/databa ... operations
- Writing a server-side script that cycles through the rows of a collection, removing them based on a set condition.
If you find that the performance is sub-optimal, you might want to establish indexes for the columns participating in the 'where' conditions before removing any data. For additional information on this, you may visit: https://docs.appery.io/docs/database-co ... ns#indexes
It's worth mentioning that our users have databases with more than 100 million records in a single collection, and these continue to operate efficiently and effectively.