Enhancement: Improve the speed of Query API operation by indexing Mongo

[akphi]

Similar requests

• I have searched and found no existing similar requests

How are you using Legend?

Legend Query

What problems are you trying to solve?

This issue technically should be filed over at https://github.com/finos/legend-engine but they auto-close stale issues there plus we might look at this when we make future improvements for query app performance, so I created an issue here instead. One thing we should think about is to index the query store for faster search - https://www.mongodb.com/blog/post/performance-best-practices-indexing - and start thinking about auto-remove queries/event

Describe the solution you would like to see implemented

TBD

Describe alternatives you have considered

No response

Documentation, Design, Adoption, Migration Strategy

No response

Contribution

• I would like to work on this feature