Sharding for parallel query performance

107 views
Skip to first unread message

Mr. Flibble

unread,
Apr 15, 2011, 5:30:51 PM4/15/11
to mongod...@googlegroups.com
Firstly - please accept my apologies for my ignorance in this area!

I am considering the pros and cons of sharding for query performance. I read that a query such as db.people.find({"email" : "te...@domain.com"}) is sent to all of the shards in serial
Is this correct? Why would this query not be sent to each of the mongod servers in parallel? 

axlfu

unread,
Apr 15, 2011, 11:20:07 PM4/15/11
to mongodb-user
http://www.mongodb.org/download/attachments/2097354/how+queries+work+with+sharding.pdf

On Apr 15, 5:30 pm, "Mr. Flibble" <conor.mccar...@gmail.com> wrote:
> Firstly - please accept my apologies for my ignorance in this area!
>
> I am considering the pros and cons of sharding for query performance. I read
> that a query such as db.people.find({"email" : "t...@domain.com"}) is sent
> to all of the shards *in serial*.

Mr. Flibble

unread,
Apr 18, 2011, 6:20:43 AM4/18/11
to mongodb-user
Thank you but this doesn't appear to answer the question. That
document says that 'Queries not involving the shard key will be sent
to all shards as a
“scatter/gather” operation'. It doesn't comment on whether this is
done in parallel across all shard machines.

On Apr 16, 4:20 am, axlfu <freesearc...@gmail.com> wrote:
> http://www.mongodb.org/download/attachments/2097354/how+queries+work+...

Eliot Horowitz

unread,
Apr 18, 2011, 9:21:21 AM4/18/11
to mongod...@googlegroups.com
Most are parallel, but a couple are still serial.
We're going to be cleaning that all up soon though:
https://jira.mongodb.org/browse/SERVER-2014

> --
> You received this message because you are subscribed to the Google Groups "mongodb-user" group.
> To post to this group, send email to mongod...@googlegroups.com.
> To unsubscribe from this group, send email to mongodb-user...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/mongodb-user?hl=en.
>
>

Reply all
Reply to author
Forward
0 new messages