Project

General

Profile

Bug #7753

Another slow query

Added by Christopher Backhouse over 4 years ago. Updated over 4 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
01/31/2015
Due date:
% Done:

0%

Estimated time:
Duration:

Description

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.

History

#1 Updated by Robert Illingworth over 4 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).

#2 Updated by Christopher Backhouse over 4 years ago

There's a list of parameters that we'll want to convert to integers circulating internally. It seems to have died in the last week or so. I'll prod it.



Also available in: Atom PDF