Azure DocumentDb "high water mark"/timestamp -
i'm looking implement process pull "new" records documentdb, new "all documents added or modified since last time process run."
sql server has rowversion this, guaranteed unique , monotonically increasing across rows , columns in database.
i see documentdb has _ts, (according documentation) used high water mark azure search indexing, how work? if multiple documents inserted @ same time read takes place, it's possible of them have same _ts value. on next read, if comparison against _ts strictly greater than, documents missed; if it's greater-than-or-equals, documents pulled second time.
is _ts safe use this?
the _ts
property specific document, not collection of documents. represents time particular document updated (in seconds, since jan 1 1970).
the _ts
property not give high water mark across documents in collection. each document has own independent _ts
property (which may have same value document's _ts
property).
see this answer bit more detail.
Comments
Post a Comment