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

Popular posts from this blog

Ansible - ERROR! the field 'hosts' is required but was not set -

customize file_field button ruby on rails -

SoapUI on windows 10 - high DPI/4K scaling issue -