This repository was archived by the owner on Nov 14, 2022. It is now read-only.
This repository was archived by the owner on Nov 14, 2022. It is now read-only.
Optimise ICAT_communication SQL Queries #107
Description
Issue raised by: [developer]
What?
Optimise SQL queries where possible within icat_communication.py
I believe that the current structure of SQL queries could be improved to be more efficient.
Where?
WebApp/autoreduce_webapp/autoreduce_webapp/icat_communication.py
How?
- Remove repetitiveness where possible.
- Optimise SQL query structure
How to test the issue is resolved
Compare optimisation of query before and after changes
Are queries simpler in design (no complex joins etc)?