Phoenix SNAPSHOT Performance

Apache Phoenix Performance Result :: Fri Jan 31 13:44:48 PST 2014

Queries by Category

1K table

select count(*) from T1K

0.02s PHOENIX-SNAPSHOT

select mypk from T1K

0.03s PHOENIX-SNAPSHOT

1K values match

select count(*) from T5M where column1 in (?,?,?...)

8.61s PHOENIX-SNAPSHOT

select count(*) from T5M JOIN T1K on T1K.mypk = T5M.column1

18.32s PHOENIX-SNAPSHOT

5M table

select count(*) from T5M

7.54s PHOENIX-SNAPSHOT

5M values match

select count(*) from T5M where column2 in (?,?,?...)

23.45s PHOENIX-SNAPSHOT

select count(*) from T5M JOIN T1K on T1K.mypk = T5M.column2

27.96s PHOENIX-SNAPSHOT

Load Data

LOAD DATA T1K [1000 ROWS]

0.2s PHOENIX-SNAPSHOT

LOAD DATA T5M [5000000 ROWS]

208.12s PHOENIX-SNAPSHOT

Queries by Table

T1K

ROWS 1000 [0M]

DDL CREATE TABLE IF NOT EXISTS $TABLE (mypk CHAR(10) NOT NULL PRIMARY KEY,CF.column1 char(10),CF.column2 char(10),CF.column3 char(10));

DATA GENERATOR
STRING :: Length: 10 Values: SEQUENTIAL
STRING :: Length: 10 Values: SEQUENTIAL
STRING :: Length: 10 Max. Value: 1000 Values: RANDOM
STRING :: Length: 10 Max. Value: 10000 Values: RANDOM