Improve datasetparameter endpoint
It is very slow for non-admins to load the summary MX page
================================================================== InstrumentScientitst: b829f78d-94f1-4da2-b870-3bbeff92d633 3354
http://ovm-icat2:8080/icat/entityManager?sessionId=b829f78d-94f1-4da2-b870-3bbeff92d633&query=SELECT parameter from DatasetParameter parameter JOIN parameter.dataset dataset JOIN parameter.type parameterType JOIN dataset.investigation investigation where investigation.id = '1405067863' and parameterType.name = 'scanType' INCLUDE parameter.type, parameter.dataset dataset, dataset.sample
144ms 274.75KB 172
http://ovm-icat2:8080/icat/entityManager?sessionId=b829f78d-94f1-4da2-b870-3bbeff92d633&query=SELECT dataset.id, dataset.name, dataset.startDate, dataset.endDate, investigation.name, parameterType.name, parameter.stringValue, parameterType.units, parameter.id, sample.id, sample.name FROM DatasetParameter as parameter JOIN parameter.dataset dataset JOIN dataset.sample sample JOIN parameter.type parameterType JOIN dataset.investigation investigation where investigation.id = '1405067863' and parameterType.name = 'scanType'
28s 35KB 172
==================================================================
Admin: d3983f66-a6ab-48a5-b4f0-106003dc178c
http://ovm-icat2:8080/icat/entityManager?sessionId=d3983f66-a6ab-48a5-b4f0-106003dc178c&query=SELECT parameter from DatasetParameter parameter JOIN parameter.dataset dataset JOIN parameter.type parameterType JOIN dataset.investigation investigation where investigation.id = '1405067863' and parameterType.name = 'scanType' INCLUDE parameter.type, parameter.dataset
122ms 239kB 172
http://ovm-icat2:8080/icat/entityManager?sessionId=d3983f66-a6ab-48a5-b4f0-106003dc178c&query=SELECT dataset.id, dataset.name, dataset.startDate, dataset.endDate, investigation.name, parameterType.name, parameter.stringValue, parameterType.units, parameter.id, sample.id, sample.name FROM DatasetParameter as parameter JOIN parameter.dataset dataset JOIN dataset.sample sample JOIN parameter.type parameterType JOIN dataset.investigation investigation where investigation.id = '1405067863' and parameterType.name = 'scanType'
23ms 35KB
==================================================================
Anymous: 0f7b170a-ab04-444a-8e59-9dc573a22ff7
http://ovm-icat2:8080/icat/entityManager?sessionId=0f7b170a-ab04-444a-8e59-9dc573a22ff7&query=SELECT parameter from DatasetParameter parameter JOIN parameter.dataset dataset JOIN parameter.type parameterType JOIN dataset.investigation investigation where investigation.id = '1405067863' and parameterType.name = 'scanType' INCLUDE parameter.type, parameter.dataset
http://ovm-icat2:8080/icat/entityManager?sessionId=d3983f66-a6ab-48a5-b4f0-106003dc178c&query=SELECT dataset.id, dataset.name, dataset.startDate, dataset.endDate, investigation.name, parameterType.name, parameter.stringValue, parameterType.units, parameter.id, sample.id, sample.name FROM DatasetParameter as parameter JOIN parameter.dataset dataset JOIN dataset.sample sample JOIN parameter.type parameterType JOIN dataset.investigation investigation where investigation.id = '1405067863' and parameterType.name = 'scanType'