I used multi_index a lot in the past.
However, since I also frequently use sqlite, I have decided to exclusively use SQLite for multi_index in memory.
If there is a problem, temporarily using sqlite as a file makes it a lot easier to track the issue. When multi_index patterns become too complex, it's natural to wrap them in a unit test specifically designed for sqlite (multi_index).
[1]: https://www.boost.org/doc/libs/1_82_0/libs/multi_index/doc/i...