is there anyway to limit the total value?

[jochman]

Hi again!
I'm using motor.

Is there any way to limit the Total value?

I couldn't find a way that isn't included in give a first $limit to aggregate then keep the paginate_aggregate as usual.

[uriyyo]

Hi @jochman,

I'm not sure I understood what you want to achieve(

You want to limit total number of returned rows by paginate_aggregate function?

[onejgordon]

I'm not sure if this is what the original question is about, but I interpreted it as a way to ceiling the number of records counted in the total response, presumably for performance reasons. Is this supported?

[uriyyo]

@onejgordon I'm not sure about that. Sorry, need to take a look. I guess this integration was done by one of contributors, I need to figure out what is going on inside implementation.

[vlance11]

Have we found a solution for this? @uriyyo it seems when dealing with large tables even when selecting the first 100 records it takes up to 15+ seconds per page.

[uriyyo]

@vlance11 Still no updates, will try to find time to investigate this issue 🙏