对子文档数组中的字段进行索引

发布于 2024-11-08 23:02:07 字数 442 浏览 0 评论 0原文

我正在尝试找出从 SQL Server 移植到 MongoDB 的消息系统的最佳设计 - 当前（在 SQL Server 中）有存储消息的树表：消息、收件箱和已发送。消息存储在消息表中，收件箱/已发送条目包含每条消息的所有收件人/发件人的条目。

现在，在 MongoDB 中，我想将这三个集合合并为一个集合，其中包含如下文档：

{
    _id: 
    subject:
    body:
    sender: {memid:, name:}
    recip: [{memid:, name:}, {memid:, name:}, {memid:, name:}, etc]

}

现在，我需要能够通过 memid 检索给定收件人的所有消息，并且我必须快速完成此操作，因此需要一个索引（我将拥有数亿个这样的条目）。所以，我的问题是 - 我可以按数组中文档的字段进行索引吗？

原文

I'm trying to figure out the best design for the messaging system I'm porting from SQL Server to MongoDB - currently (in SQL Server) there are tree tables that store the message: Messages, Inbox and Sent. The message is stored in Messages table, and Inbox/Sent have entries for all recipients/senders for each message.

Now, in MongoDB I wanted to combine those three into one collection, with documents like this:

{
    _id: 
    subject:
    body:
    sender: {memid:, name:}
    recip: [{memid:, name:}, {memid:, name:}, {memid:, name:}, etc]

}

Now, I need to be able to retrieve all messages for a given recipient by memid and I have to do it fast, so an index is required (I will have hundreds of millions of such entries). So, my question is - can I index by a field of a document in an array?

分享到QQ

分享到微博