My app needs to read the oldest event from some stream. You can say that there is nothing more easier, just use connection.ReadStreamEventsForwardAsync(“stream”, StreamPosition.Start, 1, false) and this will work. Yes, it will, but things get worse when stream has max-age and scavenging works. How in this case obtain oldest event?
It is set on the stream ($tb) and the index lookup is > $tb. As such
it is O(log n) like any other index lookup.