Well, I'm sure this thing should be a mistake ... I need to enter a month before what I'm looking for:
{ "SportId":"Horse Racing", "Date":{$gt: new Date(2012,11,4)} }
Explain the conclusion:
[ 15:21:39 ] db.Fixture.find({ "SportId" : "Horse Racing", "Date" : { "$gt" : ISODate("2012-12-04T00:00:00Z") } }).limit(50); db.Fixture.find({ "SportId" : "Horse Racing", "Date" : { "$gt" : ISODate("2012-12-04T00:00:00Z") } }).limit(50).explain();
Can anyone explain this - better than higher? It doesnβt matter, as it is now, when I know that I can get around this. But it looks rather strange.
Matt canty
source share