> > 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
