MySQL Spatial performance
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
Subject
Views
Written By
Posted
MySQL Spatial performance
5066
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.