Slowness on table

Feature(s) impacted

Client collection.

Problem

client table is too slow.

Description

Hi, we are extracting data from user collection with filters and displaying it on client table.
also, we are using the apropriate indexes for those filters.
i tested the filters with mongo Client and the filters take only 4s to get clients data.

Context

  • Project name: Roby
  • Team name: Developer
  • Environment name: UAT
  • Agent (forest package) name & version: “forest-express-mongoose”: “^8.0.0”
  • Database type: mongoDB

Hello,
Do you have any metrics or a scenario to understand why you have latencies?

hi, thank you for your response,

yes i can see how much time requests can take on mongodb.
what i see is forestadmin send two requests to mongodb: one for data, and another to count the data.

for exemple:
the data request take 6s also the count will take 6s, so it will be 12s to get result in forest.

ho we can avoid the count request?

Hello, sorry for the late reply.
You can disable the count by following this doc.
If I understand, forest takes 2s more (6s-4s) than your native request? Is it the same request? Can you share your request and the forest request please?

hi @Alban_Bertolini,
the request is “/v5.0/forest-admin/api/forest/clients”
what i wanna say in the exemple:

the total time to get result is 12s (6s+6s):
because:

  • to have data take 6s
  • to count this data take also 6s

thank you

Hello,
Have you tried disabling the count by following the documentation?
Are you still blocked?
:pray: