Is there is known difference in performance on N1QL vs get/upsert for one document ? As I upsert my doc and after it need to query it for values I wonder if it’s not better to use one way for it and go N1QL for both.
Has anyone an opinion/experience with this ?
If you operating on single document and know the docId, no filtering needed you can use get/upsert, You can also consider sub-doc option.
If you need to search by condition (no docIds) and do predicate (processing) N1QL is better option.
That is what I thought myself as well, but the same goes for inserting the docs, and multiple ones @ once ?