Description
[REQUIRED] Step 2: Describe your environment
- Operating System version: Linux
- Firebase SDK version: 13.4.0
- Firebase Product: Firestore
- Node.js version: 22
- NPM version: 10.9.2
[REQUIRED] Step 3: Describe the problem
We have simple Firestore queries, filtering on simple properties.
When fetching from backend (nodejs), it takes a very very long time.
Same query using frontend libraries takes 1% of the time.
Explain query shows that the backend query is fast, but the result takes forever to download.
If we use Firebase frontend client libraries, the same query result is loaded 50x faster.
As an example, a query with result set of 100 documents took 4 seconds to fetch with firebase-admin
1000 documents took 21 seconds to fetch with firebase-admin
This is not a network issue, as we can run the same queries on backend and frontend from same hardware, and get 50x faster results in the client libary, compared to firebase-admin.
Any idea what it could be?
It is NOT the query that is the issue, using tools we can see that correct index is used.
We can also see that result set is streamed right away.
But the actual fetching of result data takes forever with this library.
Thanks in advance
Here is a snippet from a query with result set of 1000. We can see that result is immediately starting to download.
Firestore (7.11.0) 2025-06-09T14:36:33.255Z CNebO [ClientPool.acquire]: Creating a new client (requiresGrpc: false)
Firestore (7.11.0) 2025-06-09T14:36:33.310Z ##### [clientFactory]: Initialized Firestore GAPIC Client (useFallback: rest)
Firestore (7.11.0) 2025-06-09T14:36:33.311Z CNebO [Firestore.requestStream]: Sending request: {"parent":"projects/fastorder-prod/databases/(default)/documents/company/gorilla","structuredQuery":{"from":[{"collectionId":"orders"}],"where":{"fieldFilter":{"field":{"fieldPath":"orderStatus"},"op":"NOT_EQUAL","value":{"stringValue":"ARCHIVED"}}},"limit":{"value":2}}}
Firestore (7.11.0) 2025-06-09T14:36:34.856Z CNebO [Firestore.requestStream]: Received response: {"document":{"fiel.... rest of result set