Opened 12 years ago

Closed 5 years ago

#254 closed defect (worksforme)

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

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 1.77s, selecting whole object 0.037s

rasql -q 'drop collection COLL' --user rasadmin --passwd rasadmin > /dev/null 2>&1
rasql -q 'create collection COLL GreySet' --quiet --user rasadmin --passwd rasadmin

time rasql -q 'insert into COLL values marray x in [0:1199,0:1199] values 1c tiling regular [0:99,0:99] tile size 10000 index rc_index' --user rasadmin --passwd rasadmin --quiet 

time rasql -q 'select add_cells(c) from COLL as c' --out string

RPT index: insert 1.73s, selecting whole object 0.040s

rasql -q 'drop collection COLL' --user rasadmin --passwd rasadmin > /dev/null 2>&1
rasql -q 'create collection COLL GreySet' --quiet --user rasadmin --passwd rasadmin

time rasql -q 'insert into COLL values marray x in [0:1199,0:1199] values 1c tiling regular [0:99,0:99] tile size 10000 index rpt_index' --user rasadmin --passwd  --quiet 

time rasql -q 'select add_cells(c) from COLL as c' --out string

Change History (4)

comment:1 by Dimitar Misev, 12 years ago

Description: modified (diff)

comment:2 by abeccati, 12 years ago

Milestone: → Future

comment:3 by Dimitar Misev, 5 years ago

Complexity: → Very Hard
Milestone: Future → 11.0

comment:4 by Dimitar Misev, 5 years ago

Description: modified (diff)
Milestone: 11.0 → 10.0
Resolution: → worksforme
Status: new → closed

I checked again and there's virtually no difference between the two indexes. Closing ticket.

Note: See TracTickets for help on using tickets.