mongodb sql in statement equivalent

Question

I have found two ways of doing an equivalent of SQL in statement in mongodb. One way would be something like:

BasicDBObject inQuery = new BasicDBObject();
List<Integer> list = new ArrayList<Integer>();
list.add(2);
list.add(4);
list.add(5);
inQuery.put("employeeId", new BasicDBObject("$in", list));
DBCursor cursor = collection.find(inQuery);

And the other one, with a filter, would be something like this:

FindIterable<Document> iterable = db.getCollection("coll_name")
            .find(in("field_name", values))

My questions are:

Which way is better?
Is it better to use filters? What about the performance between doing the query is the first way against using a filter?

Philipp · Accepted Answer · 2015-10-16 10:47:34Z

1

Performance-wise and semantically there is no difference.

Both result in the same command being sent to the database. The Filters.in(field, values) method is just an alternative syntax for new BasicDBObject(field, new BasicDBObject("$in", values)).

Which one you consider better from a code-stylistic point of view is your personal preference.

edited Oct 16, 2015 at 10:47

answered Oct 16, 2015 at 10:02

Philipp

70.1k10 gold badges121 silver badges159 bronze badges

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

Collectives™ on Stack Overflow

mongodb sql in statement equivalent

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related