MongoDB Array Search in Query or client side

Question

I am wondering what is better to do. I have a pulled back a query like this:

Array
(
[_id] => MongoId Object
    (
        [$id] => 4eeedd9545c717620a000007
    )
[field1] => ...
[field2] => ...
[field3] => ...
[field4] => ...
[field5] => ...
[field6] => ...

[votes] => Array
    (
        [whoVoted] => Array
            (
                [0] => 4f98930cb1445d0a7d000001
                [1] => 4f98959cb1445d0a7d000002
                [1] => 4f88730cb1445d0a7d000003
            )

    )

)

Which would be faster:

Pull that entire array in 1 query and use in_array() to find the right id?
Pull everything from the first query except the votes and then do another mongodb query to see if that id exist in the array?

David Odere · Accepted Answer · 2012-05-04 21:36:01Z

1

It Depends on a lot of factors that I suggest you test but IMO most of the time it would be faster to just do 2 querys

answered May 4, 2012 at 21:36

David Odere

3203 silver badges6 bronze badges

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

Comments

spf13 · Accepted Answer · 2012-04-30 15:15:20Z

0

Depends on the size of the array being returned / searched.

Also different servers are doing the work, what do you mean by faster? At what scale?

answered Apr 30, 2012 at 15:15

spf13

5613 silver badges9 bronze badges

1 Comment

cKendrick Over a year ago

right now the array is 200 but I expect it to jump up to more like 10,000. yes at scale

Collectives™ on Stack Overflow

MongoDB Array Search in Query or client side

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related