Phoenix Performance Result :: Mon Jan 20 11:57:28 PST 2014

---

Queries by Category

---

Join

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

select mypk from T1K 0.03s PHOENIX-SNAPSHOT

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

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

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

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

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

---

Load Data

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

LOAD DATA T5M [5000000 ROWS] 207.05s 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.02s PHOENIX-SNAPSHOT

select mypk from T1K 0.03s PHOENIX-SNAPSHOT

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

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

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

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

LOAD DATA T1K [1000 ROWS] 0.2s 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 7.87s PHOENIX-SNAPSHOT

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

---

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