Creating Multifield(more than 2) Indexes in Mongoose / MongoDB

Question

I see solution here: Creating Multifield Indexes in Mongoose / MongoDB

How about 3、4、5... fields?

Here is my coffeescript code:

selectRecordSchema = new Schema
  srcSysId: { type: String, required: true }
  desSysId: { type: String, required: true }
  stuId: { type: String, required: true }
  courseId: { type: String, required: true }

selectRecordSchema.index { srcSysId: 1, desSysId: 1,stuId: 1,courseId: 1 }, { unique: true}

And this works:

selectRecordSchema.index { srcSysId: 1, desSysId: 1}, { unique: true }

score 0 · Answer 1 · answered May 26 '14 at 13:01

0

There is no limit for field count ( while you are not hitting something like memory limit, max doc size is 16MB )

mySchema.index({field1: 1, field2: 1, field3: 1, field4: 1, field5: 1, field6: 1}, {unique: true});

answered May 26 '14 at 13:01

Adrian Toma

547
2
13

I trid,but this failed.I can create 2 same records – J22Melody May 26 '14 at 13:21
In mongoose, you if you modify schema, you must drop the collection to make the new schema work. Did you do that? – salihcenap Sep 21 '14 at 05:55

Creating Multifield(more than 2) Indexes in Mongoose / MongoDB

1 Answers1