...
Why does accessing a page like:
http://glast-tomcat03.slac.stanford.edu:8080/Pipeline-II/streams.jsp?status=RUNNING&task=1562625
take so long?
...
select processinstance from processinstance where workingdir='/nfs/farm/g/glast/u44/MC-tasks/backgnd-GR-v13r5p6/output/backgnd-GR-v13r5p6/1.0/runMonteCarlo/086xxx/360'
take 8 seconds even though we have an index on workingdir?