500 rows can be a lot of rows. A Filter query is a normal query the
first time it is run, and cached thereafter. If you do a sequence of
different time ranges, it will be slow. So, if you just do a query for
each time range, and use the query and filter query caches, they might
be faster.
On Sat,
This sounds like an "XY" problem, see:
http://people.apache.org/~hossman/#xyproblem
What is the higher-level task you're trying to accomplish?
Some things that do jump out though.
1> looping is almost always a sub-optimal solution. That's why I'm asking
about
what the higher-level task is.
2>
