Skip to content
This repository has been archived by the owner on Nov 14, 2022. It is now read-only.

Optimise ICAT_communication SQL Queries #107

Open
Pasarus opened this issue Aug 18, 2022 · 0 comments
Open

Optimise ICAT_communication SQL Queries #107

Pasarus opened this issue Aug 18, 2022 · 0 comments

Comments

@Pasarus
Copy link
Member

Pasarus commented Aug 18, 2022

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)?

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant