Forum OpenACS Q&A: Re: Closest Address Calculation

Collapse
Posted by Sam Dau on
thank you very much russel.
You just touched on something that I am very much interested in.
Someone mentioned bounding box as a way to improve performance.
If you have any links where I can find code snips about bounding box, please let me know.
I have seen an article on bounding boxes but can't figure it how to use that in a code to achieve what I am trying to achieve.

Thanks again for the help

Collapse
Posted by russ m on
My first post in the thread I linked to above adds a bounding box check to Jerry's original query. x_delta_max and y_delta_max are half the respective side lengths of the bounding box, so if your distance unit is feet and you want a 500 foot bounding box you would use 250 for each of x_delta_max and y_delta_max.