search

lukefitzwolfgang / icatproject

Automatically exported from code.google.com/p/icatproject
0 stars 0 forks source link

Add method to enable quick return of datafile by instrument + run number range #24

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Mantid needs a quick way of getting this data for locally authorised users.
Such a method would be useless off site, but would be very valuable for
ISIS instrument scientists.

There is clearly demand as SNS have implemented similar functionality.

Method would be along the lines of

DataFile[] simpleRunNumberSeach(string sessionId, string[] instruments,
number startRange, numberEndRange)

Questions include: 
1) Can we (optionally?) allow anonymous access to this method?
2) Extend to allow caller to specify a list of file extensions they are
interested in?

Original issue reported on code.google.com by tom.grif...@stfc.ac.uk on 4 Jun 2010 at 3:37

GoogleCodeExporter commented 9 years ago 
Performance of this method is crucial.
For example: the API takes ~20 seconds for a run number search on 
GEM19000-19200.
Equivalent pure SQL can get these results in ~60ms

Original comment by tom.grif...@stfc.ac.uk on 7 Jun 2010 at 9:47

GoogleCodeExporter commented 9 years ago 
Will deploy Sri's (and Hung's) EclipseLink changes to see what effect that has 
on
performance first

Original comment by tom.grif...@stfc.ac.uk on 7 Jun 2010 at 9:48

GoogleCodeExporter commented 9 years ago 
Move to EclipseLink brought query times down from 90 seconds to 7 seconds - 
which is good, but still not good enough.

I have started work on a more specific, efficient method for Mantid

Original comment by tom.grif...@stfc.ac.uk on 10 Jun 2010 at 9:19

GoogleCodeExporter commented 9 years ago

Original comment by tom.grif...@stfc.ac.uk on 27 Apr 2011 at 3:51