db.activeusers.createIndex({app: 1})
db.activeusers.createIndex({ "ts": 1 }, { expireAfterSeconds: 86400 })

db.posts.createIndex({category: 1}, { sparse: true });
db.posts.createIndex({author: 1, permlink: 1});
db.posts.createIndex({category: 1, last_reply: 1, created: 1});
db.posts.createIndex({category: 1, active: 1})
db.posts.createIndex({category: 1, active: 1, cbb: 1})

db.replies.createIndex({category: 1}, { sparse: true });
db.replies.createIndex({root_post: 1, created: 1});
db.replies.createIndex({author: 1, date: 1});

db.posts.createIndex(
  {
   title: "text",
   body: "text"
  },
  {
   weights: {
     title: 10,
     body: 5
   },
   name: "TextIndex"
  }
)

db.activeusers.createIndex({app: 1})
db.activeusers.createIndex({ "ts": 1 }, { expireAfterSeconds: 86400 })

db.posts.createIndex({category: 1}, { sparse: true });
db.posts.createIndex({author: 1, permlink: 1});
db.posts.createIndex({category: 1, last_reply: 1, created: 1});
db.posts.createIndex({category: 1, active: 1})
db.posts.createIndex({category: 1, active: 1, cbb: 1})

db.replies.createIndex({category: 1}, { sparse: true });
db.replies.createIndex({root_post: 1, created: 1});
db.replies.createIndex({author: 1, date: 1});
db.replies.createIndex({parent_author: 1, date: 1});

db.posts.createIndex(
  {
   title: "text",
   body: "text"
  },
  {
   weights: {
     title: 10,
     body: 5
   },
   name: "TextIndex"
  }
)

Create an index for replies
Create an index for replies
