I am trying to analyse speed exceedances along a route, and what I would like is a query that returns all results together (all speed exceedances), which is the result of individual section by section queries (because each section has a different speed limit). Something like the following:
(section: 1 AND speed_limit 1) OR
(section: 2 AND speed_limit 2) OR ...
(section: i AND speed_limit i) OR
Where i is quite large, maybe 1000 to cover the whole network map. Is there any harm in just combining large numbers of small queries? Is there a better way to structure them? Are there any specialist queries that could help simplify?
Probably not prior to indexing because the speed limits can change through time, I think runtime might be too much of a performance hit. We might just need to try with a large number of search settings. We did wonder about storing the results of the individual queries in a separate index but this would take away from the live nature of the system. Further thoughts welcome.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.