Phoenix Performance Result :: Sat Oct 05 20:10:21 PDT 2013
Queries by Category

Index

select count(*) from INDEX_IMMUTABLE
2.27s PHOENIX-SNAPSHOT

select count(*) from INDEX_IMMUTABLE_SALTED
0.68s PHOENIX-SNAPSHOT

select count(*) from INDEX_MUTABLE
3.3s PHOENIX-SNAPSHOT

select count(*) from INDEX_MUTABLE_SALTED
0.96s PHOENIX-SNAPSHOT

select count(*) from NO_INDEX
4.65s PHOENIX-SNAPSHOT

select count(*) from NO_INDEX_SALTED
1.17s PHOENIX-SNAPSHOT

Index Creation After Data

CREATE INDEX IDX_AFTER_LOAD_INDEX_IMMUTABLE ON INDEX_IMMUTABLE (CORE) INCLUDE (DB,ACTIVE_VISITOR)
61.21s PHOENIX-SNAPSHOT

CREATE INDEX IDX_AFTER_LOAD_INDEX_IMMUTABLE_SALTED ON INDEX_IMMUTABLE_SALTED (CORE) INCLUDE (DB,ACTIVE_VISITOR)
15.95s PHOENIX-SNAPSHOT

CREATE INDEX IDX_AFTER_LOAD_INDEX_MUTABLE ON INDEX_MUTABLE (CORE) INCLUDE (DB,ACTIVE_VISITOR)
61.4s PHOENIX-SNAPSHOT

CREATE INDEX IDX_AFTER_LOAD_INDEX_MUTABLE_SALTED ON INDEX_MUTABLE_SALTED (CORE) INCLUDE (DB,ACTIVE_VISITOR)
15.12s PHOENIX-SNAPSHOT

CREATE INDEX IDX_AFTER_LOAD_NO_INDEX ON NO_INDEX (CORE) INCLUDE (DB,ACTIVE_VISITOR)
60.14s PHOENIX-SNAPSHOT

CREATE INDEX IDX_AFTER_LOAD_NO_INDEX_SALTED ON NO_INDEX_SALTED (CORE) INCLUDE (DB,ACTIVE_VISITOR)
14.34s PHOENIX-SNAPSHOT

Load Data

LOAD DATA INDEX_IMMUTABLE [1000000 ROWS]
69.8s PHOENIX-SNAPSHOT

LOAD DATA INDEX_IMMUTABLE_SALTED [1000000 ROWS]
65.93s PHOENIX-SNAPSHOT

LOAD DATA INDEX_MUTABLE [1000000 ROWS]
159.55s PHOENIX-SNAPSHOT

LOAD DATA INDEX_MUTABLE_SALTED [1000000 ROWS]
100.87s PHOENIX-SNAPSHOT

LOAD DATA NO_INDEX [1000000 ROWS]
48.72s PHOENIX-SNAPSHOT

LOAD DATA NO_INDEX_SALTED [1000000 ROWS]
44.32s PHOENIX-SNAPSHOT



Queries by Table

INDEX_IMMUTABLE




ROWS 1000000 [1M]

DDL CREATE TABLE $TABLE (HOST CHAR(2) NOT NULL,DOMAIN VARCHAR NOT NULL,FEATURE VARCHAR NOT NULL,DATE DATE NOT NULL,USAGE.CORE BIGINT,USAGE.DB BIGINT,STATS.ACTIVE_VISITOR INTEGER CONSTRAINT PK PRIMARY KEY (HOST, DOMAIN, FEATURE, DATE)) IMMUTABLE_ROWS=true;CREATE INDEX IDX_ON_LOAD_$TABLE ON $TABLE (CORE,DB,ACTIVE_VISITOR);

DATA GENERATOR
STRING :: Values: NA|CS|EU
STRING :: Values: Salesforce.com|Apple.com|Google.com|Yelp.com
STRING :: Values: Login|Report|Dashboard|Sales|UI
DATE :: Values: SEQUENTIAL
INTEGER :: Max. Value: 100 Values: RANDOM
INTEGER :: Max. Value: 2000 Values: RANDOM
INTEGER :: Max. Value: 10000 Values: RANDOM

select count(*) from INDEX_IMMUTABLE
2.27s PHOENIX-SNAPSHOT

CREATE INDEX IDX_AFTER_LOAD_INDEX_IMMUTABLE ON INDEX_IMMUTABLE (CORE) INCLUDE (DB,ACTIVE_VISITOR)
61.21s PHOENIX-SNAPSHOT

LOAD DATA INDEX_IMMUTABLE [1000000 ROWS]
69.8s PHOENIX-SNAPSHOT

INDEX_IMMUTABLE_SALTED




ROWS 1000000 [1M]

DDL CREATE TABLE $TABLE (HOST CHAR(2) NOT NULL,DOMAIN VARCHAR NOT NULL,FEATURE VARCHAR NOT NULL,DATE DATE NOT NULL,USAGE.CORE BIGINT,USAGE.DB BIGINT,STATS.ACTIVE_VISITOR INTEGER CONSTRAINT PK PRIMARY KEY (HOST, DOMAIN, FEATURE, DATE)) IMMUTABLE_ROWS=true,SALT_BUCKETS=4;CREATE INDEX IDX_ON_LOAD_$TABLE ON $TABLE (CORE,DB,ACTIVE_VISITOR);

DATA GENERATOR
STRING :: Values: NA|CS|EU
STRING :: Values: Salesforce.com|Apple.com|Google.com|Yelp.com
STRING :: Values: Login|Report|Dashboard|Sales|UI
DATE :: Values: SEQUENTIAL
INTEGER :: Max. Value: 100 Values: RANDOM
INTEGER :: Max. Value: 2000 Values: RANDOM
INTEGER :: Max. Value: 10000 Values: RANDOM

select count(*) from INDEX_IMMUTABLE_SALTED
0.68s PHOENIX-SNAPSHOT

CREATE INDEX IDX_AFTER_LOAD_INDEX_IMMUTABLE_SALTED ON INDEX_IMMUTABLE_SALTED (CORE) INCLUDE (DB,ACTIVE_VISITOR)
15.95s PHOENIX-SNAPSHOT

LOAD DATA INDEX_IMMUTABLE_SALTED [1000000 ROWS]
65.93s PHOENIX-SNAPSHOT

INDEX_MUTABLE




ROWS 1000000 [1M]

DDL CREATE TABLE $TABLE (HOST CHAR(2) NOT NULL,DOMAIN VARCHAR NOT NULL,FEATURE VARCHAR NOT NULL,DATE DATE NOT NULL,USAGE.CORE BIGINT,USAGE.DB BIGINT,STATS.ACTIVE_VISITOR INTEGER CONSTRAINT PK PRIMARY KEY (HOST, DOMAIN, FEATURE, DATE));CREATE INDEX IDX_ON_LOAD_$TABLE ON $TABLE (CORE,DB,ACTIVE_VISITOR);

DATA GENERATOR
STRING :: Values: NA|CS|EU
STRING :: Values: Salesforce.com|Apple.com|Google.com|Yelp.com
STRING :: Values: Login|Report|Dashboard|Sales|UI
DATE :: Values: SEQUENTIAL
INTEGER :: Max. Value: 100 Values: RANDOM
INTEGER :: Max. Value: 2000 Values: RANDOM
INTEGER :: Max. Value: 10000 Values: RANDOM

select count(*) from INDEX_MUTABLE
3.3s PHOENIX-SNAPSHOT

CREATE INDEX IDX_AFTER_LOAD_INDEX_MUTABLE ON INDEX_MUTABLE (CORE) INCLUDE (DB,ACTIVE_VISITOR)
61.4s PHOENIX-SNAPSHOT

LOAD DATA INDEX_MUTABLE [1000000 ROWS]
159.55s PHOENIX-SNAPSHOT

INDEX_MUTABLE_SALTED




ROWS 1000000 [1M]

DDL CREATE TABLE $TABLE (HOST CHAR(2) NOT NULL,DOMAIN VARCHAR NOT NULL,FEATURE VARCHAR NOT NULL,DATE DATE NOT NULL,USAGE.CORE BIGINT,USAGE.DB BIGINT,STATS.ACTIVE_VISITOR INTEGER CONSTRAINT PK PRIMARY KEY (HOST, DOMAIN, FEATURE, DATE)) SALT_BUCKETS=4;CREATE INDEX IDX_ON_LOAD_$TABLE ON $TABLE (CORE,DB,ACTIVE_VISITOR);

DATA GENERATOR
STRING :: Values: NA|CS|EU
STRING :: Values: Salesforce.com|Apple.com|Google.com|Yelp.com
STRING :: Values: Login|Report|Dashboard|Sales|UI
DATE :: Values: SEQUENTIAL
INTEGER :: Max. Value: 100 Values: RANDOM
INTEGER :: Max. Value: 2000 Values: RANDOM
INTEGER :: Max. Value: 10000 Values: RANDOM

select count(*) from INDEX_MUTABLE_SALTED
0.96s PHOENIX-SNAPSHOT

CREATE INDEX IDX_AFTER_LOAD_INDEX_MUTABLE_SALTED ON INDEX_MUTABLE_SALTED (CORE) INCLUDE (DB,ACTIVE_VISITOR)
15.12s PHOENIX-SNAPSHOT

LOAD DATA INDEX_MUTABLE_SALTED [1000000 ROWS]
100.87s PHOENIX-SNAPSHOT

NO_INDEX




ROWS 1000000 [1M]

DDL CREATE TABLE $TABLE (HOST CHAR(2) NOT NULL,DOMAIN VARCHAR NOT NULL,FEATURE VARCHAR NOT NULL,DATE DATE NOT NULL,USAGE.CORE BIGINT,USAGE.DB BIGINT,STATS.ACTIVE_VISITOR INTEGER CONSTRAINT PK PRIMARY KEY (HOST, DOMAIN, FEATURE, DATE));

DATA GENERATOR
STRING :: Values: NA|CS|EU
STRING :: Values: Salesforce.com|Apple.com|Google.com|Yelp.com
STRING :: Values: Login|Report|Dashboard|Sales|UI
DATE :: Values: SEQUENTIAL
INTEGER :: Max. Value: 100 Values: RANDOM
INTEGER :: Max. Value: 2000 Values: RANDOM
INTEGER :: Max. Value: 10000 Values: RANDOM

select count(*) from NO_INDEX
4.65s PHOENIX-SNAPSHOT

CREATE INDEX IDX_AFTER_LOAD_NO_INDEX ON NO_INDEX (CORE) INCLUDE (DB,ACTIVE_VISITOR)
60.14s PHOENIX-SNAPSHOT

LOAD DATA NO_INDEX [1000000 ROWS]
48.72s PHOENIX-SNAPSHOT

NO_INDEX_SALTED




ROWS 1000000 [1M]

DDL CREATE TABLE $TABLE (HOST CHAR(2) NOT NULL,DOMAIN VARCHAR NOT NULL,FEATURE VARCHAR NOT NULL,DATE DATE NOT NULL,USAGE.CORE BIGINT,USAGE.DB BIGINT,STATS.ACTIVE_VISITOR INTEGER CONSTRAINT PK PRIMARY KEY (HOST, DOMAIN, FEATURE, DATE)) SALT_BUCKETS=4;

DATA GENERATOR
STRING :: Values: NA|CS|EU
STRING :: Values: Salesforce.com|Apple.com|Google.com|Yelp.com
STRING :: Values: Login|Report|Dashboard|Sales|UI
DATE :: Values: SEQUENTIAL
INTEGER :: Max. Value: 100 Values: RANDOM
INTEGER :: Max. Value: 2000 Values: RANDOM
INTEGER :: Max. Value: 10000 Values: RANDOM

select count(*) from NO_INDEX_SALTED
1.17s PHOENIX-SNAPSHOT

CREATE INDEX IDX_AFTER_LOAD_NO_INDEX_SALTED ON NO_INDEX_SALTED (CORE) INCLUDE (DB,ACTIVE_VISITOR)
14.34s PHOENIX-SNAPSHOT

LOAD DATA NO_INDEX_SALTED [1000000 ROWS]
44.32s PHOENIX-SNAPSHOT


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