Hi, On Sat, 2002-02-23 at 01:14, Tod Harter wrote: > This is an example of a class of problem that crops up in a lot of > applications, like GIS systems all the time. > > Unfortunately B-Tree type indexes, like RDBMS systems generally use are just > not well adapted to this type of query. I know Informix had a "Data Blade" > for Universal Server that provided some indexing strategies for this type of > thing, but that is a pretty expensive solution... > > There are several ways to build indexes for this sort of stuff, but in MySQL > you would essentially have to design a new table handler. Given MySQL's > flexibility in that respect it is conceivable that someone will provide > products like that in the future.
Hmm, maybe just a new index type, not a complete new table handler. Would R-tree indexes (and OpenGIS functions) make you happy? Regards, Arjen. -- MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php