N1QL Update vs a mutation via the sdk?

Couchbase Server
,
1

Theoretically what would give better performance if I want to update a single field in a big document.

N1QL update statement or a subdocument mutation via the sdk?

Thanks,

2

sub document mutation from sdk. N1QL works on whole document

1 Like
3

Even if I do an update statement like
UPDATE test USE KEYS 'key' SET inactive=true

Does this result in N1QL pulling the whole document, modifying the field and then persist?

I was under the impression that N1QL would do a mutation behind the scenes. Can you confirm please?

4

N1QL always pulls whole document for update

1 Like