嵌入对象及其他索引问题
In a recent design review, the customer's application was in production, but performance had taken a nosedive as data volumes grew. It turned out that the issue was down to how they were indexing...
在最近的设计评审中,客户的应用因数据量增加导致性能下降,主要问题在于文档中嵌入对象的索引方式。尽管有110K可查询文档和15个索引,但索引占用85GB内存,超出4GB缓存,影响性能。建议采用复合索引和部分索引,以优化查询性能并减少索引大小。
-zo2x9zzcu1.png)