MySQL Forums
Forum List  »  GIS

MySQL Spatial performance
Posted by: Lukasz Nowak
Date: August 26, 2011 01:20AM

Hi,
I've checked query execution times using MBRContains function. I have 1mln random records (points) put on the surface 500x500. The query execution times are:
1) Area 50x50 | 0,11sec | 9963 records
2) 100x100 | 0,35 sec | 40013
3) 200x200 | 1,176 sec | 160009
4) 300x300 | 0,482 sec | 359126
5) 400x400 | 0,765 sec | 639874

Why times in 4) and 5) are shorter than in 3). The areas and records number are greater...

Sorry for my english

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Spatial performance
4689
August 26, 2011 01:20AM


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.