Slow query to fetch the last sequence-nr. of the ingest member

Informatievlaanderen / VSDS-LDESServer4J

Linked Data Event Streams Server for Java

https://informatievlaanderen.github.io/VSDS-LDESServer4J

European Union Public License 1.2

8 stars 8 forks source link

Slow query to fetch the last sequence-nr. of the ingest member #1253

Closed jobulcke closed 2 weeks ago

jobulcke commented 3 months ago

The query the retrieve the last processed member is slow:

{"find":"ingest_ldesmember","filter":{"collectionName":"observations","sequenceNr":{"$gt":{"$numberLong":"2068"}}},"sort":{"sequenceNr":{"$numberInt":"1"}},"limit":{"$numberInt":"1"},"$db":"vsds?retryWrites=false","lsid":{"id":{"$binary":{"base64":"i/drCK4FT4SERFKMA045UQ==","subType":"04"}}},"$readPreference":{"mode":"primaryPreferred"}}

Yalz commented 2 weeks ago

Data model en retrieval of Ingest model has changed. Deprecated issue