...
The response time is 3.7 seconds.
A GIST index has been built.
The response time is 02. 03 seconds.
The most recent versions of Mysql provide geospatial functionnalities. These extensions follow the OpenGIS specifications.
...
select id, time, energy rom events where ra_min < ra and ra < ra_max and dec_min < dec and dec < dec_max
The response time is around 0.35 65 second.
The following statement has been sent to the database :
select id, time, energy from events where MBRIntersects(error ,
GeomFromText('POLYGON((ra_max dec_max, ra_max dec_min, ra_min dec_min, ra_min dec_max, ra_max dec_max)', -1))
The response time is 85.2 7 seconds.
An index has been built.
The response time is 0.004 4 seconds.