Richard Lynch wrote: > On Sat, January 26, 2008 3:45 am, Per Jessen wrote: >> Nathan Rixham wrote: >> >>>Back on the mysql side of things, try using geometry columns rather >>>than numerical primary keys, with spatial indexes.. it's a MASSIVE >>>performance upgrade (I've cut 5 second queries down to 0.005 by using >>>geo columns) >> >> Uh, could you could elaborate a bit on that (whilst I go and do some >> googling)? > > If you are doing geography/geometry stuff, spatial indices can be > nice. >
OK, what is a 'geometry column' and what is a 'spatial index' ? /Per Jessen, Zürich -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
