Exeray ArrayDB Achieves fast query speed

ArrayDB’s data query speed is also significantly faster. With 3 millions records each in table t1 and t2, we performed a simple join of the two tables on the key userid. The following result shows the query performance under Commercial Enterprise and ArrayDB:

Commmercial Enterprise:

sql> select t1.userid, t1.addr, t2.msgid from t1, t2 where t1.userid=t2.userid;

USERID ADDR MSGID
—————- —————- —————-
peach     orange    orange
cherry     red         red
apple      green     green
mango    orange   orange
banana   yellow    yellow

Elapsed: 00:00:24.09

We ran the query again:

sql> select t1.userid, t1.addr, t2.msgid from t1, t2 where t1.userid=t2.userid;

USERID ADDR MSGID
—————- —————- —————-
peach     orange    orange
cherry     red         red
apple      green     green
mango    orange   orange
banana   yellow    yellow

Elapsed: 00:00:10.04

ArrayDB:

rdb> join t1, t2 on key;
userid addr msgid
—————- —————- —————-
apple        green       green
banana    yellow     yellow
cherry     red           red
mango    orange    orange
peach     orange     orange
server time is 268 milliseconds
—————————————————
Done in 307 milliseconds

The query speed is about 37X of Commercial Enterprise even we used the time of the second query. Multiple runs of data query have used the system’s cached data which makes the query faster than reading cold data.

Advertisements