From: Rob Wultsch (wultschgmail.com)
Date: Fri Apr 25 2008 - 10:52:31 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Fri, Apr 25, 2008 at 12:27 AM, Chris W <2wsxdr5cox.net> wrote:
> I just did a quick look at the documentation on the mysql spatial extension
> and it seems like over kill for what you are looking for. An easy way to
> approximate the search for all points a given distance from another is to
> simply use a bounding box. An index on the X and Y coordinates of the point
> then will make the search fast. something like this...
>
> SELECT *
> FROM points
> WHERE x >= minx AND x <= maxx AND y >= miny AND y <= maxy

Thank you for your response. While I rather dislike using hacks the
above would probably work well enough for my purposes.

Unfortunately I do most of my work in a version of MySQL <5.0
(3.23.49) so I don't have access to the index merge optimization so
the above would only use one index for me, but that would probably be
good enough. One more reason to try to get my sys admin to upgrade...

--
Rob Wultsch
wultschgmail.com
wultsch (aim)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]