[
https://issues.apache.org/jira/browse/PHOENIX-3853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16021758#comment-16021758
]
Rajeshbabu Chintaguntla commented on PHOENIX-3853:
--------------------------------------------------
[~mujtabachohan] can you try running the perf tests with
https://issues.apache.org/jira/secure/attachment/12869519/PHOENIX-3827_v5.patch?
I thinks local indexes are better with v5 patch :)
> Local Index - Writes to local index are twice as slow as global and get
> exponentially slower with PHOENIX-3827_v2 patch
> -----------------------------------------------------------------------------------------------------------------------
>
> Key: PHOENIX-3853
> URL: https://issues.apache.org/jira/browse/PHOENIX-3853
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.10.0
> Environment: HBase 1.3.1 4GB heap in local mode
> Reporter: Mujtaba Chohan
> Fix For: 4.11.0
>
> Attachments: after_3858.png, batch_mutable.png, batch_time.png,
> PHOENIX-3853_test_only.patch
>
>
> HBase 1.3.1 with head of Phoenix 4.x with/without PHOENIX-3827 v2 patch
> applied. This is with immutable non-covered local/global index on a single
> column with varying batch size when writing data to base table plus index.
> !batch_time.png!
> | Batch Size | Local Index with PHOENIX-3827_v2 patch (sec)| Local Index
> without PHOENIX-3827_v2.patch (sec)| Global (sec)|
> | 100 | 0.02 | 0.03 | 0.013 |
> | 1000 | 0.3 | 0.3 | 0.13 |
> | 10000 | 4.3 | 2.6 | 1.3 |
> | 12500 | 8.1 | 3 | 1.6 |
> | 15000 | 13.3 | 3.1 | 1.9 |
> Schema and index
> {noformat}
> CREATE TABLE IF NOT EXISTS T (OID CHAR(15) NOT NULL, PKP CHAR(3) NOT NULL,
> PIH CHAR(15) NOT NULL, FD DATE NOT NULL, SB CHAR(15) NOT NULL, BJ CHAR(15),
> JR VARCHAR, FIELD VARCHAR, YM VARCHAR, WN VARCHAR, LG VARCHAR, XHJ VARCHAR,
> HF VARCHAR, GA VARCHAR, MX VARCHAR, NZ DECIMAL, JV DECIMAL, AG DATE, KV DATE,
> JK VARCHAR, DK VARCHAR, EU DATE, OE VARCHAR, DV INTEGER, IK VARCHAR
> CONSTRAINT PK PRIMARY KEY ( OID, PKP, PIH, FD DESC, SB ))
> VERSIONS=1,IMMUTABLE_ROWS=true
> CREATE INDEX IF NOT EXISTS IDXT ON T (JV)
> {noformat}
> Data CSV
> https://expirebox.com/download/1cea73af1831b5193f0539d6e3442292.html
> [~rajeshbabu], [~lhofhansl], [~jamestaylor]
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
