Changes between Initial Version and Version 1 of Ticket #254
- Timestamp:
- Dec 17, 2012, 12:05:29 AM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #254 – Description
initial v1 1 1 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. 2 2 3 RC index: 6s3 RC index: insert 6s, selecting whole object 2.7s 4 4 {{{ 5 5 insert into COLL values marray x in [0:1199,0:1199] values 1c tiling regular [0:99,0:99] index rc_index 6 7 select c from COLL as c 6 8 }}} 7 9 8 RPT index: 0. 2s10 RPT index: 0.18s, selecting whole object 0.17s 9 11 {{{ 10 12 insert into COLL values marray x in [0:1199,0:1199] values 1c tiling regular [0:99,0:99] index rpt_index 13 14 select c from COLL as c 11 15 }}}