Regular computed index much slower than R+ tree index

[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

[Dimitar Misev]

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