Delete Query on a large database


#1

I have a qustion about a delete query on a large database. Is there a good way to do this? Is it deleting directly every record that matches without loading it in memory first?


#2

Yes. it will lookup the internal document id’s and deletes them. this commit improved it by not loading the id’s into memory but using stored fields instead: https://github.com/crate/crate/commit/4bafcae4a5eafa64f01374b7c83fefe16bf56196