Table 2 Spatial query performance within a circle for 100 MB data set
Circle radius & prec. | SEQ_AGG (ms) | SEQ_no_AGG (ms) | AS_AGG (ms) | AS_no_AGG (ms) |
|---|---|---|---|---|
10 m, 9 | 57.6 | 184.6 | 9.6 | 43.6 |
100 m, 9 | 773.75 | 2681.5 | 89.25 | 237.75 |
1 km, 9 | 7610.67 | 23,004 | 1123.83 | 1175.67 |
10 km, 9 | 232,494.5 | 224,630.5 | 52,851.5 | 5456 |