Regular computed index much slower than R+ tree index
|Reported by:||dmisev||Owned by:||dmisev|
Description (last modified by dmisev)
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: insert 6s, selecting whole object 2.7s
insert into COLL values marray x in [0:1199,0:1199] values 1c tiling regular [0:99,0:99] index rc_index select c from COLL as c
RPT index: 0.18s, selecting whole object 0.17s
insert into COLL values marray x in [0:1199,0:1199] values 1c tiling regular [0:99,0:99] index rpt_index select c from COLL as c