Styjun

Why can't we play rap on piano?

What reasons are there for a Capitalist to oppose a 100% inheritance tax?

Is "remove commented out code" correct English?

Do UK voters know if their MP will be the Speaker of the House?

Would Slavery Reparations be considered Bills of Attainder and hence Illegal?

How dangerous is XSS?

How to prevent "they're falling in love" trope

What are some good books on Machine Learning and AI like Krugman, Wells and Graddy's "Essentials of Economics"

iPad being using in wall mount battery swollen

What do you call someone who asks many questions?

Is there a hemisphere-neutral way of specifying a season?

One verb to replace 'be a member of' a club

A category-like structure without composition?

Intersection Puzzle

How do I deal with an unproductive colleague in a small company?

Solving a recurrence relation (poker chips)

What is the most common color to indicate the input-field is disabled?

What does “the session was packed” mean in this context?

How do conventional missiles fly?

In 'Revenger,' what does 'cove' come from?

How can I deal with my CEO asking me to hire someone with a higher salary than me, a co-founder?

Can we compute the area of a quadrilateral with one right angle when we only know the lengths of any three sides?

Avoiding direct proof while writing proof by induction

How do I handle a potential work/personal life conflict as the manager of one of my friends?

Get number of documents in a big collection in Cloud Firestore

How to get a count of number of documents in a collection with Cloud FirestoreNodejs, Cloud Firestore Upload Tasks - Auth error:Error: socket hang upAccess a cloud firestore document within a cloud functionFirestore - Get document collectionsGet/add Document in Cloud functions using FirestoreIs it possible to get all documents in a Firestore Cloud Function?firestore cloud functions for getting aggregated values in collectionHow to count documents in cloud firestore?Getting document ID in Firebase Cloud Functions (Firestore)How to get documents with an array that contains a string? Cloud Firestore & Cloud Functions

1

I know this question was already asked but I'm being specific about my case: I've got a large database (approximately 1 million documents inside the collection users).

I wanna get the exact number of documents inside users. I'm trying this:

export const count_users = functions.https.onRequest((request, response) => 
 corsHandler(request, response, () => 

 db.collection('users').select().get().then(
 (snapshot) => response.json(snapshot.docs.length)
 )
 .catch(function(error) 
 console.error("[count_users] Error counting users: ", error);
 response.json("Failed");
 );
 );
);

Although it seems right, it takes forever to give me a result. I'm not allowed to add or remove documents from the database.

Is there any possible approach for getting this quantity?

google-cloud-firestore google-cloud-functions

share|improve this question

asked Mar 21 at 21:15

DanielDaniel

1,160721

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I don't think your case is any different than the other cases for counting documents in a collection. What's unique here?
  
  – Doug Stevenson
  Mar 21 at 22:24
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I'm specifying that my collection is very large and that I'm not allowed to add or remove documents from it (and this seems to be a requirement for the solutions out there).
  
  – Daniel
  Mar 21 at 22:27
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If the collection can't change size by adding or removing documents, why do you need to query it at all? Just use the known size.
  
  – Doug Stevenson
  Mar 21 at 22:28
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This is the problem, I don't know the size. I uploaded 1 million documents but the cloud functions logs told me that some of the adding operations failed and I can't be sure there are actually 1 million documents at all. I need to make sure that nothing is missing.
  
  – Daniel
  Mar 21 at 22:30
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  1) increase the timeout on the function to max 9 minutes. or 2) Don't run it in Cloud Functions; run it in a Cloud shell instead, or even your desktop.
  
  – Doug Stevenson
  Mar 21 at 22:44
  

  
  
  
  

 | 
show 2 more comments

1

I know this question was already asked but I'm being specific about my case: I've got a large database (approximately 1 million documents inside the collection users).

I wanna get the exact number of documents inside users. I'm trying this:

export const count_users = functions.https.onRequest((request, response) => 
 corsHandler(request, response, () => 

 db.collection('users').select().get().then(
 (snapshot) => response.json(snapshot.docs.length)
 )
 .catch(function(error) 
 console.error("[count_users] Error counting users: ", error);
 response.json("Failed");
 );
 );
);

Although it seems right, it takes forever to give me a result. I'm not allowed to add or remove documents from the database.

Is there any possible approach for getting this quantity?

google-cloud-firestore google-cloud-functions

share|improve this question

asked Mar 21 at 21:15

DanielDaniel

1,160721

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I don't think your case is any different than the other cases for counting documents in a collection. What's unique here?
  
  – Doug Stevenson
  Mar 21 at 22:24
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I'm specifying that my collection is very large and that I'm not allowed to add or remove documents from it (and this seems to be a requirement for the solutions out there).
  
  – Daniel
  Mar 21 at 22:27
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If the collection can't change size by adding or removing documents, why do you need to query it at all? Just use the known size.
  
  – Doug Stevenson
  Mar 21 at 22:28
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This is the problem, I don't know the size. I uploaded 1 million documents but the cloud functions logs told me that some of the adding operations failed and I can't be sure there are actually 1 million documents at all. I need to make sure that nothing is missing.
  
  – Daniel
  Mar 21 at 22:30
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  1) increase the timeout on the function to max 9 minutes. or 2) Don't run it in Cloud Functions; run it in a Cloud shell instead, or even your desktop.
  
  – Doug Stevenson
  Mar 21 at 22:44
  

  
  
  
  

 | 
show 2 more comments

I know this question was already asked but I'm being specific about my case: I've got a large database (approximately 1 million documents inside the collection users).

I wanna get the exact number of documents inside users. I'm trying this:

export const count_users = functions.https.onRequest((request, response) => 
 corsHandler(request, response, () => 

 db.collection('users').select().get().then(
 (snapshot) => response.json(snapshot.docs.length)
 )
 .catch(function(error) 
 console.error("[count_users] Error counting users: ", error);
 response.json("Failed");
 );
 );
);

Although it seems right, it takes forever to give me a result. I'm not allowed to add or remove documents from the database.

Is there any possible approach for getting this quantity?

google-cloud-firestore google-cloud-functions

share|improve this question

asked Mar 21 at 21:15

DanielDaniel

1,160721

export const count_users = functions.https.onRequest((request, response) => 
 corsHandler(request, response, () => 

 db.collection('users').select().get().then(
 (snapshot) => response.json(snapshot.docs.length)
 )
 .catch(function(error) 
 console.error("[count_users] Error counting users: ", error);
 response.json("Failed");
 );
 );
);

share|improve this question

asked Mar 21 at 21:15

DanielDaniel

1,160721

share|improve this question

asked Mar 21 at 21:15

DanielDaniel

1,160721

asked Mar 21 at 21:15

DanielDaniel

1,160721

asked Mar 21 at 21:15

DanielDaniel

1,160721