We discovered in
#2975334-19: Prevent changes that would leak into the Live workspace →
that a very complex entity query which joins the base entity table multiple times also has to join the workspace_association table for each of them.
Figure out a solution to only join the workspace_association table once per entity type.
TBD.
Nope.
Nope.
Nope.
Postponed
11.0 🔥
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
The suggestion from #8 was implemented in 📌 Track the workspace of a revision in a base field and convert the workspace_association entity type to a custom index Fixed , but it didn't help with the problem described in this issue.
I think 📌 Optimize joins and table selection in SQL entity query implementation Needs work has a very big potential to help with workspace's query alters, so postponing on that issue.