Another slow query
Should a query like this work?
time samweb count-files defname: prod_caf_FA14-12-29_nd_genie_nonswap_postshutdown or defname: prod_caf_FA14-12-29_nd_genie_nonswap_preshutdown_downsampled
It's been running for maybe an hour now. I can probably construct a better query, but it would have been convenient if this one worked. If it's invalid somehow it should have been rejected by the parser.
#1 Updated by Robert Illingworth over 5 years ago
With some messing around with the query evaluator I've managed to make this execute in 30s. Of course, there's always the worry that changing anything may make other queries slower.
This particular query has a "simulated.firstrun <= 10407" in it, where simulated.firstrun is actually a string. This tends to make it slower - you should consider requesting this and similar parameters are converted to numerics (which can be done, although it's a little disruptive; either we have to shut down the server, or there will be a period where you can get the wrong answer).