Opened 12 years ago
Last modified 5 years ago
#254 closed defect
Regular computed index much slower than R+ tree index — at Initial Version
| Reported by: | Dimitar Misev | Owned by: | Dimitar Misev |
|---|---|---|---|
| Priority: | minor | Milestone: | 10.0 |
| Component: | indexmgr | Version: | 8.3 |
| Keywords: | Cc: | Peter Baumann | |
| Complexity: | Very Hard |
Description
Fixing ticket #161 has revealed that the RC index is much slower than the RPT index, even though the idea of the RC index is to be faster for regular tiling.
RC index: 6s
insert into COLL values marray x in [0:1199,0:1199] values 1c tiling regular [0:99,0:99] index rc_index
RPT index: 0.2s
insert into COLL values marray x in [0:1199,0:1199] values 1c tiling regular [0:99,0:99] index rpt_index
Note:
See TracTickets
for help on using tickets.
