Wanted to know is there a limit on the number of keys i can use to query / delete.
i.e.
I am creating a list of which may contain 400K ID’s(KEYS) , can i use that number of Keys while deleting it.
checkpoint_ids = [
“400K ID’s in this list”
]
cb_query_construct = N1QLQuery(‘delete from bucket use keys $1’, checkpoint_ids)
If you have the keys, it will probably be more efficient to delete directly using one of the SDKs.
If you need to query first to find the matching keys, you can query for the meta().id and then do a delete directly from the bucket using an SDK. That will probably be more efficient, if you need the last mile of performance. On many platforms, this will use a streaming parser from the N1QL response, so you can efficiently fire off async deletes.