Opened 5 years ago

Last modified 4 years ago

#254 new defect

Regular computed index much slower than R+ tree index

Reported by: dmisev Owned by: dmisev
Priority: minor Milestone: Future
Component: indexmgr Version: 8.3
Keywords: Cc: pbaumann
Complexity:

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

Change History (2)

comment:1 Changed 5 years ago by dmisev

  • Description modified (diff)

comment:2 Changed 4 years ago by abeccati

  • Milestone set to Future
Note: See TracTickets for help on using tickets.