嵌入对象及其他索引问题

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缓存,影响性能。建议采用复合索引和部分索引,以优化查询性能并减少索引大小。

嵌入对象及其他索引问题
原文英文,约1600词,阅读约需6分钟。发表于:
阅读原文