[
https://issues.apache.org/jira/browse/PHOENIX-1536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14251440#comment-14251440
]
Rajeshbabu Chintaguntla commented on PHOENIX-1536:
--------------------------------------------------
Here are the perf number
{code}
0: jdbc:phoenix:localhost> explain select count(*) from
LOCAL_INDEXED_TABLE_WIDE;
+------------------------------------------+
| PLAN |
+------------------------------------------+
| CLIENT 32-CHUNK PARALLEL 32-WAY RANGE SCAN OVER
_LOCAL_IDX_LOCAL_INDEXED_TABLE_WIDE [-32768] |
| SERVER AGGREGATE INTO SINGLE ROW |
+------------------------------------------+
2 rows selected (0.026 seconds)
0: jdbc:phoenix:localhost> select count(*) from LOCAL_INDEXED_TABLE_WIDE;
+------------------------------------------+
| COUNT(1) |
+------------------------------------------+
| 3000000 |
+------------------------------------------+
1 row selected (1.152 seconds)
0: jdbc:phoenix:localhost> select /*+NO_INDEX*/ count(*) from LOCAL
LOCAL LOCAL_INDEXED_TABLE_WIDE.DB
0: jdbc:phoenix:localhost> select /*+NO_INDEX*/ count(*) from
LOCAL_INDEXED_TABLE_WIDE;
+------------------------------------------+
| COUNT(1) |
+------------------------------------------+
| 3000000 |
+------------------------------------------+
1 row selected (1.751 seconds)
0: jdbc:phoenix:localhost> explain select /*+NO_INDEX*/ count(*) from
LOCAL_INDEXED_TABLE_WIDE;
+------------------------------------------+
| PLAN |
+------------------------------------------+
| CLIENT 32-CHUNK PARALLEL 1-WAY FULL SCAN OVER LOCAL_INDEXED_TABLE_WIDE |
| SERVER AGGREGATE INTO SINGLE ROW |
+------------------------------------------+
2 rows selected (0.013 seconds)
0: jdbc:phoenix:localhost>
{code}
> Make use of SplitTransaction to split local index region from 0.98.9 onwards
> ----------------------------------------------------------------------------
>
> Key: PHOENIX-1536
> URL: https://issues.apache.org/jira/browse/PHOENIX-1536
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.2.2
> Reporter: Rajeshbabu Chintaguntla
> Fix For: 5.0.0, 4.3
>
> Attachments: PHOENIX-1536.patch
>
>
> Currently we are using IndexSpilitTransaction which is duplicate of
> SplitTransaction with minor changes. From 0.98.9 onwards we can use the
> SplitTransaction itself.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
