Don't use union query, it's very slow in MySQL.
The new changes is from 1 complex SQL to N simple SQL.
In our complex data environment, the Users#show page response time reduce from 5s to 500ms.
The new changes is from 1 complex SQL to N simple SQL.
In our complex data environment, the Users#show page response time reduce from 5s to 500ms.