Changes between Version 1 and Version 4 of Ticket #254


Ignore:
Timestamp:
Mar 17, 2020, 5:20:10 PM (5 years ago)
Author:
Dimitar Misev
Comment:

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

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #254

    • Property Status new → closed
    • Property Complexity → Very Hard
    • Property Resolution → worksforme
    • Property Milestone → 10.0

  • Ticket #254 – Description

    v1 v4  
    11Fixing 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.
    22
    3 RC index: insert 6s, selecting whole object 2.7s
     3RC index: insert 1.77s, selecting whole object 0.037s
    44{{{
    5 insert into COLL values marray x in [0:1199,0:1199] values 1c tiling regular [0:99,0:99] index rc_index
     5rasql -q 'drop collection COLL' --user rasadmin --passwd rasadmin > /dev/null 2>&1
     6rasql -q 'create collection COLL GreySet' --quiet --user rasadmin --passwd rasadmin
    67
    7 select c from COLL as c
     8time 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
     9
     10time rasql -q 'select add_cells(c) from COLL as c' --out string
    811}}}
    912
    10 RPT index: 0.18s, selecting whole object 0.17s
     13RPT index: insert 1.73s, selecting whole object 0.040s
    1114{{{
    12 insert into COLL values marray x in [0:1199,0:1199] values 1c tiling regular [0:99,0:99] index rpt_index
     15rasql -q 'drop collection COLL' --user rasadmin --passwd rasadmin > /dev/null 2>&1
     16rasql -q 'create collection COLL GreySet' --quiet --user rasadmin --passwd rasadmin
    1317
    14 select c from COLL as c
     18time 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
     19
     20time rasql -q 'select add_cells(c) from COLL as c' --out string
    1521}}}