hi. do we have any difference in
# spicedb
t
hi. do we have any difference in performance when deleting relationship using /v1/relationships/write with relationship update (with OPERATION_DELETE) and using /v1/relationships/delete with relationship filter? in both cases we use the same combination of object+subject+relation
v
in postgres it would likely be more efficient to call delete relationships API. But the more important aspect is not performance, but that each API has different uses: - the former allows you to transactionally perform deletes with other operations like create / touch. Delete API does not support this - the latter supports deleting large numbers of relationships using limits, which is key to make sure you don't overload your database
12 Views