database search with multiple criteria is very slow

I'm using the python interface. I find that when I add a 4th condition to the selection string, the query becomes very much slower, so much so that if I run it over the whole run range, it looks dead.

Would it be possible to streamline the queries under the hood, or have it run each part of the query over the results of the previous part, or is there a way for me to do that easily myself in python?

Please try my example, it is really surprising how much slower it becomes when I use the full query string, and here I am only searching over a small number of runs.

import rcdb db = rcdb.RCDBProvider("mysql://rcdb@hallddb/rcdb2") selection = "@is_production and not @is_empty_target and cdc_gas_pressure >=99.8" runs = db.select_runs(selection,30274, 30300) selection = "@is_production and not @is_empty_target and cdc_gas_pressure >=99.8 and cdc_gas_pressure<=100.2" runs = db.select_runs(selection,30274, 30300)

JeffersonLab / rcdb

database search with multiple criteria is very slow #111