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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s