Database access optimisation: Delete a gene in a panel
Description: Deleting a gene in a panel creates many queries? SQL queries hitting to database as follows:
- User unlock the gene then click delete icon
- GET /panels/{id}/gene/{symbol}/delete
- 41 queries +/-
Version tested: 3.1.1
Steps to reproduce locally:
- DEBUG flag on
- Debug Toolbar on
- View a gene in a panel with existing entities of 1600++ (e.g. download and import this panel https://panelapp.agha.umccr.org/panels/250/); try with (or without) some reviews, comments and feedbacks.
- Monitor console logs and Debug Toolbar profiling on SQL queries.
Issues:
- Affecting performance and slow responsiveness
- Not ideal database access operation
- UI/UX: No progress show on delete operation; if it happens to take longer time