Page History

...

Sample Data are stored in a relational database.
A perl script is run to retrieve events located in a region defined by ra_max, dec_max, ra_min,dec_min. (typically 2x2 degrees).
The time spent by the query as well as the number of events found is kept.
The query is launched 100 times, statistics are output.

...

select * from events where ra_min < ra and ra < ra_max and dec_min < dec and dec < dec_max
The response time is around 1.second. On 100 queries the average number of events found is 50.

statement with geo functions

select * from events where point(ra,dec) @ box ra_max,dec_max, ra_min,dec_min
The response time is around 1.2 second.