Table 4 Spatial query performance within a circle for 1 GB data set
Circle radius and prec. | SEQ_AGG (ms) | SEQ_no_AGG (ms) | AS_AGG (ms) | AS_no_AGG (ms) |
|---|---|---|---|---|
10 m, 9 | 52.2 | 167 | 6 | 35.2 |
100 m, 9 | 700.75 | 2320.5 | 76 | 205.25 |
1 km, 9 | 7803.5 | 23,151.67 | 1042.17 | 996.5 |
10 km, 9 | 237,636.33 | 238,607.33 | 53,568.67 | 5687 |