search

frmscoe / General-Issues

This repo exists to track current work and any issues within the FRMS CoE
2 stars 0 forks source link

Default deployment indexes are incorrect in ArangoDB #379

Closed Justus-at-Tazama closed 3 months ago

Justus-at-Tazama commented 4 months ago

e.g. the pacs.008 collection in transactionHistory database contains an index for EndToEndId at the root of the incoming message, but this causes a second incoming message to fail on an index conflict.

Image

Acceptance criteria

  1. Recommend a review of all indexes set up during a deployment and alignment with the indexes identified out of performance benchmarking.
johanfol commented 4 months ago

Update: Indexes from 5-Fetch-Indexes, created in "Create All Indexes" script, is being moved to 2-Create-Indexes folder instead, as individual indexes. Rodney will also create necessary document therefore.

rtkay123 commented 3 months ago

Fixed with: https://github.com/frmscoe/postman/pull/42

Relevant docs: https://github.com/frmscoe/docs/blob/main/Technical/Database/arango-db-deployment-indexes.md