Skip to content

Too slow to retrieve samples for instrumentScientists

This takes ~20s:

2024-10-07T12:05:31.169Z [debug]: getSamplesBy.  
  				 sessionId : 42c7937b-3894-472c-a619-b6cc81bd0d29
				 investigationId : 1758666594
				 sampleIds : undefined
				 limit : 20
				 skip : 0
				 search : 
				 sortBy : undefined
				 sortOrder : undefined
				 datasetType : undefined
				 startDate : undefined
				 endDate : undefined
				 includeDatasets : undefined
				 nested : undefined
				 parameters : undefined
				 havingAcquisitionDatasets : undefined
				 instrumentName : undefined

2024-10-07T12:05:31.170Z [debug]: http://ovm-icat1:8080/icat/entityManager?sessionId=42c7937b-3894-472c-a619-b6cc81bd0d29&query=select distinct(sample) from Sample sample JOIN sample.investigation investigation LEFT JOIN sample.parameters parameters LEFT JOIN parameters.type parameterType  JOIN investigation.investigationInstruments investigationInstruments JOIN investigationInstruments.instrument instrument    WHERE  investigation.id = '1758666594'  order by sample.modTime DESC    INCLUDE sample.parameters parameters, parameters.type, sample.investigation investigation, investigation.investigationInstruments investigationInstruments, investigationInstruments.instrument instrument   LIMIT 0, 20  
  
2024-10-07T12:05:31.170Z [debug]: http://ovm-icat1:8080/icat/entityManager?sessionId=42c7937b-3894-472c-a619-b6cc81bd0d29&query=select count(distinct(sample)) from Sample sample JOIN sample.investigation investigation LEFT JOIN sample.parameters parameters LEFT JOIN parameters.type parameterType  JOIN investigation.investigationInstruments investigationInstruments JOIN investigationInstruments.instrument instrument    WHERE  investigation.id = '1758666594'  order by sample.modTime DESC     
  
2024-10-07T12:05:31.170Z [debug]: http://ovm-icat1:8080/icat/entityManager?sessionId=42c7937b-3894-472c-a619-b6cc81bd0d29&query=select count(distinct(sample)) from Sample sample JOIN sample.investigation investigation LEFT JOIN sample.parameters parameters LEFT JOIN parameters.type parameterType  JOIN investigation.investigationInstruments investigationInstruments JOIN investigationInstruments.instrument instrument    WHERE  investigation.id = '1758666594'  order by sample.modTime DESC     
  
2024-10-07T12:05:50.526Z [debug]: GET /catalogue/42c7937b-3894-472c-a619-b6cc81bd0d29/samples?investigationId=1758666594&search=&limit=20 [CLOSED] 19,365.841 ms