Phoenix Performance Result :: Tue Jan 21 12:05:15 PST 2014

Queries by Category


1K table

select count(*) from T1K
0.04s PHOENIX-SNAPSHOT

select mypk from T1K
0.03s PHOENIX-SNAPSHOT


1K values match

select count(*) from T5M where column1 in (?,?,?...)
7.95s PHOENIX-SNAPSHOT

select count(*) from T5M JOIN T1K on T1K.mypk = T5M.column1
17.6s PHOENIX-SNAPSHOT


5M table

select count(*) from T5M
8.19s PHOENIX-SNAPSHOT


5M values match

select count(*) from T5M where column2 in (?,?,?...)
22.28s PHOENIX-SNAPSHOT

select count(*) from T5M JOIN T1K on T1K.mypk = T5M.column2
26.84s PHOENIX-SNAPSHOT


Load Data

LOAD DATA T1K [1000 ROWS]
0.3s PHOENIX-SNAPSHOT

LOAD DATA T5M [5000000 ROWS]
209.64s 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

select count(*) from T1K
0.04s PHOENIX-SNAPSHOT

select mypk from T1K
0.03s PHOENIX-SNAPSHOT

select count(*) from T5M where column1 in (?,?,?...)
7.95s PHOENIX-SNAPSHOT

select count(*) from T5M where column2 in (?,?,?...)
22.28s PHOENIX-SNAPSHOT

select count(*) from T5M JOIN T1K on T1K.mypk = T5M.column1
17.6s PHOENIX-SNAPSHOT

select count(*) from T5M JOIN T1K on T1K.mypk = T5M.column2
26.84s PHOENIX-SNAPSHOT

LOAD DATA T1K [1000 ROWS]
0.3s PHOENIX-SNAPSHOT


T5M




ROWS 5000000 [5M]

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

select count(*) from T5M
8.19s PHOENIX-SNAPSHOT

LOAD DATA T5M [5000000 ROWS]
209.64s PHOENIX-SNAPSHOT



Note: Hover over version label to see Phoenix Query Explain Plan.