@spinscale--Thanks for the tip. I am aware that what I currently have is search-intensive. Another question I have is: is there some equivalent of a cron job that I could run periodically--say daily and presumably outside of peak hours--to update my time_to_closure statistic for an existing index?
Also, while we're on the topic of time processing, do you have any advice regarding another of my recent posts?
[Scanning Window Search through Index?](Scanning Window Search through Index?
I'm still struggling with figuring out how to sweep through an index in time with a time coordinate--let's just call it t--whose value I control (say by updating in a loop) and comparing various time field values with t to determine things like what tickets are open at a given moment, and how long have they been open.
Thanks and all the best...