| 1 | Used queries:
|
|---|
| 2 | -------------
|
|---|
| 3 | 1) Create collection
|
|---|
| 4 | rasql -q 'create collection test GreySet' --user rasadmin --passwd rasadmin
|
|---|
| 5 | 2) Insert query
|
|---|
| 6 | rasql -q 'insert into test values marray i in [0:100,0:100] values 1c tiling aligned [0:1,0:1] tile size 4' --user rasadmin --passwd rasadmin
|
|---|
| 7 | 3) Select query
|
|---|
| 8 | rasql -q 'select sdom(c) from test as c' --out string
|
|---|
| 9 |
|
|---|
| 10 | Time measurement results:
|
|---|
| 11 | -------------------------
|
|---|
| 12 |
|
|---|
| 13 | - run on home computer (slower)
|
|---|
| 14 |
|
|---|
| 15 | =============================================================
|
|---|
| 16 | | Lockmgr versions | create | insert | select |
|
|---|
| 17 | =============================================================
|
|---|
| 18 | | Original lockmgr | 0.081s | 2.083s | 7.745s |
|
|---|
| 19 | =============================================================
|
|---|
| 20 | | No lockmgr | 0.067s | 2.060s | 0.055s |
|
|---|
| 21 | =============================================================
|
|---|
| 22 | | Original lockmgr, no lock call | 0.062s | 2.360s | 2.873s |
|
|---|
| 23 | =============================================================
|
|---|
| 24 | | Optimized lockmgr (curr. ver.) | 0.160s | 2.836s | 2.291s |
|
|---|
| 25 | =============================================================
|
|---|
| 26 |
|
|---|
| 27 | - run on university computer
|
|---|
| 28 |
|
|---|
| 29 | =============================================================
|
|---|
| 30 | | Lockmgr versions | create | insert | select |
|
|---|
| 31 | =============================================================
|
|---|
| 32 | | Optimized lockmgr (curr. ver.) | 0.045s | 1.718s | 0.878s |
|
|---|
| 33 | =============================================================
|
|---|