Stream performance optimization

[yuri]

No need. I think we'd rather remove any forced indexing here, as datasets can be different. One CRM can have a lot of private posts, less subscription, other -- the opposite.

[dimyy]

Maybe add the ability at the ORM level (query builder) to force indexes for flexible adjustment of a specific instance?

[yuri]

At ORM level not possible. On the service level yes, but need to come up with design how to make it user-friendly. There are lot of queries, would be hard to figure out.

I tested a query with ACL filters and UNIQUE was making performance worse, while making it 3-fold better w/o ACL joins.