Just want to again say thanks for this query. It seriously sped up part of my program.
Aren On Thu, May 12, 2011 at 1:27 PM, Aren Cambre <a...@arencambre.com> wrote: > This is a perfect example of a place where you could push some work out of >> the application and into the database. You can consolidate your 1 to 101 >> queries into a single query. If you use: >> >> WHERE rte_nm='SH71' AND rm >= 206 AND rm <= 306 ORDER BY abs(rm - 256), rm >> - 256 DESC LIMIT 1 >> >> it will always return the same value as the first matching query from your >> list, and will never have to make more than one trip to the database. Your >> one trip might be slightly slower than any one of the single trips above, >> but it will certainly be much faster in the case where you have to hit any >> significant % of your 101 potential queries. >> > > THANKS!! I've been obsessing so much about parallelism that I hadn't spent > much time finding better queries. > > Aren >
