How can I determine the CPU and RAM requirements based on data size?

[Kushagra_Kesav]

Hey @Rajan_Braiya,

Welcome to the MongoDB Community forums

@Rajan_Braiya

Although the current sizes are relatively small, we are experiencing slowdowns in API response, particularly when making a ‘get-all’ request on the dominant collection.

To better understand the scenario, could you please share the workflow you followed to run the query, the explain output of the same, and the sample document?

@Rajan_Braiya

• Which factor, CPU, RAM, or network performance, is responsible for the operation speed?
• What steps should we take to improve the response time?

It depends on various factors, including your schema design and the complexity of the query you are planning to execute.

@Rajan_Braiya

If we decide to go with a subscription plan, should we choose a serverless or dedicated option?

Serverless is more suitable for workloads that are not consistent. However, if you are expecting a consistent workload, then a dedicated server would be a good choice. It depends on your preference and workload. To learn more about serverless and dedicated servers, please refer to the FAQ - Atlas Serverless Instances.

@Rajan_Braiya

If we opt for a dedicated server, how can we determine the CPU and RAM requirements based on the collection size and number of documents?

As per my knowledge, it doesn’t depend on the collection size; it depends on the working set. It could be the case that you have a huge dataset, but the working set could be small. Also, MongoDB Atlas provides an auto-scaling feature that you can configure, and MongoDB Atlas will automatically scale your cluster tier, storage capacity, or both in response to cluster usage.

Look forward to hearing from you.

Regards,
Kushagra