The tests were run on a PC running Slackware Linux with a kernel 2.6.9. The CPU was a P4 2.80GHz, the RAM was 512 Mb (which was too small).
Database parameters were set to their default values. No optimization was attempted.
Data are considered to be spread on a rectangular plane. The spherical geometry is not taken into account.
Postgresql, since a long time, has implemented geospatial features.
...
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.3 second.
The This statement has been used :
select id, time, energy from events where sdo_filter(error, sdo_geometry(2003, null, null, sdo_elem_info_array(1,1003,3), sdo_ordinate_array(ra_min, dec_min, ra_max, dec_max))) = true
For this command to work an index must be created.
The response time is around 0.8 second.