Phoenix Performance Result :: Thu Jul 11 10:37:38 PDT 2013

---

AGGREGATION_TEST_TABLE
Various server side grouped/un-grouped aggregation functions. Data is pre-split in 9 regions over a 4 region server cluster.

ROWS 10000000 [10M]

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)) SPLIT ON ('CSGoogle','CSSalesforce','EUApple','EUGoogle','EUSalesforce','NAApple','NAGoogle','NASalesforce')

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

QUERIES

select count(*) from AGGREGATION_TEST_TABLE 7.5s CURRENT-SNAPSHOT 7.01s PHOENIX-1.1 7.16s PHOENIX-1.2.0

select count(1) from AGGREGATION_TEST_TABLE group by HOST 7.81s CURRENT-SNAPSHOT 7.37s PHOENIX-1.1 7.41s PHOENIX-1.2.0

select MIN(CORE) from AGGREGATION_TEST_TABLE group by DOMAIN 8.7s CURRENT-SNAPSHOT 8.19s PHOENIX-1.1 8.33s PHOENIX-1.2.0

select core, count(1) from AGGREGATION_TEST_TABLE group by CORE 8.46s CURRENT-SNAPSHOT 8.11s PHOENIX-1.1 8.24s PHOENIX-1.2.0

select core, host, sum(ACTIVE_VISITOR) from AGGREGATION_TEST_TABLE group by core, host 13.53s CURRENT-SNAPSHOT 13.35s PHOENIX-1.1 13.41s PHOENIX-1.2.0

select AVG(DB), MIN(CORE), MAX(ACTIVE_VISITOR) from AGGREGATION_TEST_TABLE where host='CS' and DOMAIN<>'Google.com' 18.22s CURRENT-SNAPSHOT 16.36s PHOENIX-1.1 18.17s PHOENIX-1.2.0

select round(date, 'day',50), sum(core)+2 from AGGREGATION_TEST_TABLE where (CORE<10 or CORE>90) group by round(date, 'day',50), host 5.97s CURRENT-SNAPSHOT 5.55s PHOENIX-1.1 5.89s PHOENIX-1.2.0

select trunc(date, 'hour', 1000), count(DB), count(ACTIVE_VISITOR) from AGGREGATION_TEST_TABLE where feature='Login' and (core<50 or db<20 or active_visitor > 200) group by trunc(date, 'hour', 1000) 8.34s CURRENT-SNAPSHOT 11s PHOENIX-1.1 7.87s PHOENIX-1.2.0

select count(active_visitor) count from AGGREGATION_TEST_TABLE 12.25s CURRENT-SNAPSHOT 11.91s PHOENIX-1.1 11.71s PHOENIX-1.2.0

select count(distinct active_visitor) count from AGGREGATION_TEST_TABLE 13.43s CURRENT-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select percentile_cont(0.9) within group (order by active_visitor asc) from AGGREGATION_TEST_TABLE 13.38s CURRENT-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select percentile_cont(0.1) within group (order by active_visitor desc) from AGGREGATION_TEST_TABLE 13.38s CURRENT-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select count(core), count(db), count(active_visitor) from AGGREGATION_TEST_TABLE 16.98s CURRENT-SNAPSHOT 16.34s PHOENIX-1.1 16.23s PHOENIX-1.2.0

select count(distinct core), count(distinct db), count(distinct active_visitor) from AGGREGATION_TEST_TABLE 19.12s CURRENT-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select percentile_cont(0.5) within group (order by core asc), percentile_cont(0.5) within group (order by db asc), percentile_cont(0.5) within group (order by active_visitor asc) from AGGREGATION_TEST_TABLE 18.92s CURRENT-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select core, count(db) count from AGGREGATION_TEST_TABLE group by CORE 12.66s CURRENT-SNAPSHOT 12.43s PHOENIX-1.1 11.99s PHOENIX-1.2.0

select core, count(distinct db) count from AGGREGATION_TEST_TABLE group by CORE 15.55s CURRENT-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select core, percentile_cont(0.9999) within group (order by db asc) from AGGREGATION_TEST_TABLE group by CORE 16.05s CURRENT-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

LOAD DATA [10000000 ROWS] 318.58s CURRENT-SNAPSHOT 292.82s PHOENIX-1.1 350.21s PHOENIX-1.2.0