MongoDB Expert to work on Enterprise Site maintenance for a long time.
$30-250 USD
Cerrado
Publicado hace casi 4 años
$30-250 USD
Pagado a la entrega
Hello, Freelancers.
We are using aggregate on mongodb. But getting the issue on the performance.
I am willing to give $50 who can resolve this speed issue.
This example aggregate gets the number of documents that are matched to “[login to view URL] : true”.
[login to view URL]('example').aggregate([
{
$lookup: {
from: "users",
localField: "userId",
foreignField: "userId",
as: "user"
}
},
{$match: {[login to view URL] : true}}
{ $count: "total_count" }
])
This aggregate takes more than 4 seconds now.
When I remove the $count, it takes 0.173 secs.
How can it speed up to 0.173 secs when using the $count?
$count is same to $group:{_id: null, total_count:{$sum: 1}} so this question is how to speed up the group after lookup stage?
Thanks, all.
Hello,
I'm proficient with Node.js and MongoDB. I have solved multiple speed issues in MongoDB and Postgres. In one of my project, text search on fields was taking around 30 seconds, after optimizing the queries and creating indexes, I was able to reduce the timing to 2 seconds. I think I will be able to help you.
Let me know if you have any questions.
Hello,
I am currently working as MongoDB DBA in a MNC. I can help with u these in nearly an hour or two. Please consider me.
waiting for ur reply.
Thanks,
Peeyush