Changes between Initial Version and Version 1 of Ticket #254


Ignore:
Timestamp:
Dec 17, 2012, 12:05:29 AM (11 years ago)
Author:
Dimitar Misev
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #254 – Description

    initial v1  
    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: 6s
     3RC index: insert 6s, selecting whole object 2.7s
    44{{{
    55insert into COLL values marray x in [0:1199,0:1199] values 1c tiling regular [0:99,0:99] index rc_index
     6
     7select c from COLL as c
    68}}}
    79
    8 RPT index: 0.2s
     10RPT index: 0.18s, selecting whole object 0.17s
    911{{{
    1012insert into COLL values marray x in [0:1199,0:1199] values 1c tiling regular [0:99,0:99] index rpt_index
     13
     14select c from COLL as c
    1115}}}