Tweet
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.
-
If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks. -
Maybe add the ability at the ORM level (query builder) to force indexes for flexible adjustment of a specific instance?Comment
-
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.If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.Comment
Comment