How is mongoDB performance on array field queries?

Question

I'm a db newb in general, looking to use mongoDB for the first time. Wondering what the performance would be like for a query similar to the following (O(n*m) complexity) on a collection with 500K-1M documents. Basically, my question is: At what collection size would one likely start seeing performance issues for a query like this? TIA

db.albums.find(
  {
    genres: 'Alternative Rock' 
  } 
)

There isn't a good general answer. Try it with your schema and on your hardware and driver platform. Also, you'll need to consider what other indexes and queries you will want. Like, what if a search is for genre and music-decade? — WiredPrairie
– WiredPrairie, Commented May 4, 2013 at 12:08

Thilo · Accepted Answer · 2013-05-04 04:42:26Z

4

That is a very straight-forward index-access query (if you index genres).

Just like with any other database, you'd have a B-tree index, I would not expect performance issues for 500K - 1M records.

answered May 4, 2013 at 4:42

Thilo

264k107 gold badges527 silver badges674 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Sergio Tulentsev Over a year ago

@lciamp: That's why he has 80k+ rep :)

Thilo Over a year ago

@SergioTulentsev: I like to think that the quality of my answers has something to do with that as well, but I concede that speed and quantity are big factors :-)

lciamp Over a year ago

@Thilo Hey, I was just joking around. But, yeah, your answer is actually of higher quality than mine! I think sergio was joking around too. We're all friends here!

lciamp · Accepted Answer · 2013-05-05 01:09:56Z

3

It really depends. With mongo, speed comes down to indexes. If you set up an index for that query, it could happen quite fast. (even for a 1M+ query)

Ex:

db.albums.ensureIndex({'genres':-1})

edited May 5, 2013 at 1:09

answered May 4, 2013 at 4:42

lciamp

6851 gold badge10 silver badges19 bronze badges

Collectives™ on Stack Overflow

How is mongoDB performance on array field queries?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related