9

I was using mongo driver for java 2.x and passed to 3.1. DBCursor is deprecated and I had to use the FindIterable<Document> structure.

When I perform a query 

FindIterable<Document> cursor=(mongo).getCollection().find(findArgs).limit(10).skip(0);

I would like to get the count of the total number of records in the resultset with the query find in only one Query.

How can I retrieve the count without performing another query? I'm not speaking of the 10 records in the limit but of the total number of records.

I want to perform one query to retrieve count and find. I don't want to execute find and count.

Thanks

jeorfevre
  • 2,286
  • 1
  • 17
  • 27

7 Answers7

1

There is count method available. It's accepts Bson filter. So after getting the collection object, you can directly put the count function.

MongoCollection<Document> collection = db.getCollection(collectionName);
long totalFilteredRecords = collection.count("field","value");
Derrick
  • 3,669
  • 5
  • 35
  • 50
user1370393
  • 67
  • 1
  • 4
1

You can use this :

(mongo).getCollection().count(findArgs);
user3693142
  • 11
  • 2
  • 2
    While this code snippet may solve the question, [including an explanation](//meta.stackexchange.com/questions/114762/explaining-entirely-code-based-answers) really helps to improve the quality of your post. Remember that you are answering the question for readers in the future, and those people might not know the reasons for your code suggestion. Please also try not to crowd your code with explanatory comments, this reduces the readability of both the code and the explanations! – kayess Jul 21 '16 at 15:02
1

FindIterable is basically an iterator. Iterators do not know the total size of the elements they will return. The best way I have found to do this is to create a single "query map" but with two query operations (a find and a count).

Something like this (groovy):

Map query = [_id: [$in:idList]]

FindIterable userList = User.collection.find(query).skip(offset).limit(max)

Integer totalCount = User.collection.count(query)

I know that this was not what you where after, but I believe what you want is not possible.

Another way would be to use aggregation (mongodb version 3.4+), but not sure if that would be better for you. Here

Eduardo Mayer
  • 359
  • 1
  • 3
  • 10
1

This is an old question. A typical answer is to use the count() method. However it's not always a preferred method considering performance.

To execute count() method, the MongoDB server has to iterate over all the documents that matches the filter. It will be extremely slow and uses lots of load if the total-matching document number is large, and the winning plan is not an optimal one.

A common strategy, is to projection the result to help MongoDB optimize winning plan. Thus, very likely, the winning plan is an optimal one. It will faster than pure count().

Then, using Iterable size method (e.g. the one from guava), the code looks like:

Iterable<?> it = table.find(filterBson).projection(new Document("_id", 1));
int count = Iterables.size(it);
JieYuan Shen
  • 11
  • 1
0

While this question is old and you may have already found your answer, i'll post this to a newbie like myself who's struggling something as small as this. Without any Querying you can directly use "Count"

mongoClient = new MongoClient("localhost", 27017);
              DB db = mongoClient.getDB("DatabaseName");
              DBCollection coll = db.getCollection("CollectionName");
              long count = coll.count();

Hope it helps!

AACaN
  • 90
  • 2
  • 8
0

MongoCollection.count() is deprecated in the newer version. You can use:

long result = collection.countDocuments(findArgs);

e.g.

long result = collection.countDocuments(eq("_id", idValue));
pushkin
  • 9,575
  • 15
  • 51
  • 95
B.Z.
  • 418
  • 5
  • 12
0

int size = Iterators.size(cursor.iterator());

They wanted a count of the records. cursor.iterator() gets you an iterator object. Iterators.size() gets you the count of records in the iterator.

Dominic Giallombardo
  • 945
  • 10
  • 8