MySQL Forums
Forum List  »  GIS

Advanced Search
New Topic

Re: Why my query took so long
Posted by: Albert Rovira
Date: December 22, 2009 10:21AM

Because the query don't use RTREE indexs after all.

In order to improve this query you can add an new field with a LINE GEOMETRY. Create an RTREE index on this field. And query it with MBRCONTAINS() ... Remember that this function give false positives.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Why my query took so long
3849
kittys seattle
December 09, 2009 11:58AM
Re: Why my query took so long
2230
Albert Rovira
December 22, 2009 10:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.