I don’t know what the query looks like, but a typical problem with LIMIT is that it happens after the cost has happened. That is, it’s often more like a “post” filter than a “pre” filter.
I don’t know what the query looks like, but a typical problem with LIMIT is that it happens after the cost has happened. That is, it’s often more like a “post” filter than a “pre” filter.