Opened 12 years ago

Last modified 5 years ago

#254 closed defect

Regular computed index much slower than R+ tree index — at Version 1

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 (last modified by Dimitar Misev)

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 (1)

comment:1 by Dimitar Misev, 12 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.