[OSM-talk] Server slowness

Iván Sánchez Ortega ivansanchez at escomposlinux.org
Sun Jan 14 14:51:17 GMT 2007


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

El Domingo 14 de Enero de 2007 04:56, Nick Hill escribió:
> This could cause a substantial hit for queries hitting Europe. Our database
> currently narrows the index down on either lat or lon, not both.

Why doesn't OSM use MySQL's spatial extensions, then? If the 'latitude' 
and 'altitude' columns are merged into a single column of type 'Point', you 
can narrow the search by both lat and long, defining a bounding rectangle.

- -- 
- ----------------------------------
Iván Sánchez Ortega <ivansanchez at escomposlinux.org>

Now listening to: Hooverphonic - No More Sweet Music (disc 2) (2005) - [8] 
Heartbeat (remixed by Alex Callier) (3:52) (99%)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFqkNpR56dWuhgxGgRAn1LAKCRTl82jf08agJiZVrZC9BjP3BX9QCgps3Z
c5IyzBpGQi9VP4WZ5j9WsKc=
=PGWh
-----END PGP SIGNATURE-----




More information about the talk mailing list