Database access optimisation: Compare two panels
Description: Comparing two panels create many queries? SQL queries hitting to database as attached images. This will be as bad as, for local benchmarking on comparing panels with 1667 entities vs 3993 entities create 11349 queries!
Steps to reproduce locally:
- DEBUG flag on
- Debug Toolbar on
- Compare two panels with varying entities
- Monitor console logs and Debug Toolbar profiling on SQL queries.
- Affecting performance and slow responsiveness
- Not ideal database access operation
- Unable to compare very large panels (i.e. comparing panels with 10K++ gene entities)