常见数据库

Aerospike

单节点

采用HHD

put test users user1 ‘{"name":"zxx","age":25}‘

:print          ---打印统计信息

>>

  time:    0.24000 ms          ----耗时

  success: 1

  failure: 0

[root@node2 ~]# ascli eval

get test users user1            ----获取数据

{"name": "zxx", "age": 25}

:reset                                 ---重置统计信息

:repeat 10                    

{"name": "zxx", "age": 25}

{"name": "zxx", "age": 25}

{"name": "zxx", "age": 25}

{"name": "zxx", "age": 25}

{"name": "zxx", "age": 25}

{"name": "zxx", "age": 25}

{"name": "zxx", "age": 25}

{"name": "zxx", "age": 25}

{"name": "zxx", "age": 25}

{"name": "zxx", "age": 25}

:print

>>

  time:    0.55500 ms

  success: 10

  failure: 0

:quit

每条读取速度55.5微秒

TimesTen

单进程插入

插入clxsgj，插入一次提交一次。插入10000条总共花费时间：127.38毫秒

平均每条插入时间：12.738微秒

单进程读

读取clxsgj，从10000条中全表读取一条数据：879微秒

Oracle

单进程插入

插入clxsgj，插入一次提交一次。插入10000条总共花费时间：1279毫秒

平均每条插入时间：127.9微秒

单进程读

读取clxsgj，从10000条中全表读取一条数据：280000微秒

可以看出：

TimesTen读速度是Oracle单条读的318倍

TimesTen写速度是Oracle单条写的10倍

存储过程

TimesTen测试写入速度性能

create or replace procedure in_data

is

i number ;

begin

i :=0;

while(i < 10000)

loop

i := i+1;

insert into zxx.clxsgj_zxx (CLGJID, FWBH, XXLSH, JKDBH, CDFX, JGSJ, RKSJ, CDBH, HPHM, HPYS, TXSL, LXML, TXML, TXMC1, TXMC2, TXMC3, TXMC4, CLSD, XSZT, CLPP, CLWX, CSYS, CLLX, HPZL, CLBJ, CLR, CLRQ, SJLY, CFR, TXMC5, TXMC6)

values (i, ‘kj000001‘, 3340642, ‘3201211026 ‘, ‘2 ‘, to_date(‘22-07-2015 09:00:03‘, ‘dd-mm-yyyy hh24:mi:ss‘), to_date(‘22-07-2015 09:05:58‘, ‘dd-mm-yyyy hh24:mi:ss‘), ‘2 ‘, ‘云AME037 ‘, ‘2 ‘, 2, ‘kk01‘, ‘kk/2015/07/22/09/3201211023/‘, ‘云A589S1-1.jpg‘, ‘云A589S1-2.jpg‘, ‘云A9T580-3.jpg‘, ‘‘, 0, ‘1 ‘, ‘‘, ‘‘, ‘‘, ‘‘, ‘02 ‘, 0, null, null, ‘‘, 0, ‘‘, ‘‘);

end loop;

end;

TimesTen测试读速度

select * from zxx.clxsgj_zxx where clgjid=999;

Oracle测试读速度

select * from zxx.clxsgj_zxx where clgjid=999;

Oracle测试写入速度性能

create or replace procedure in_data

is

i number ;

begin

i :=0;

while(i < 10000)

loop

i := i+1;

insert into zxx.clxsgj_zxx (CLGJID, FWBH, XXLSH, JKDBH, CDFX, JGSJ, RKSJ, CDBH, HPHM, HPYS, TXSL, LXML, TXML, TXMC1, TXMC2, TXMC3, TXMC4, CLSD, XSZT, CLPP, CLWX, CSYS, CLLX, HPZL, CLBJ, CLR, CLRQ, SJLY, CFR, TXMC5, TXMC6)

values (i, ‘kj000001‘, 3340642, ‘3201211026 ‘, ‘2 ‘, to_date(‘22-07-2015 09:00:03‘, ‘dd-mm-yyyy hh24:mi:ss‘), to_date(‘22-07-2015 09:05:58‘, ‘dd-mm-yyyy hh24:mi:ss‘), ‘2 ‘, ‘云AME037 ‘, ‘2 ‘, 2, ‘kk01‘, ‘kk/2015/07/22/09/3201211023/‘, ‘云A589S1-1.jpg‘, ‘云A589S1-2.jpg‘, ‘云A9T580-3.jpg‘, ‘‘, 0, ‘1 ‘, ‘‘, ‘‘, ‘‘, ‘‘, ‘02 ‘, 0, null, null, ‘‘, 0, ‘‘, ‘‘);

commit;

end loop;

end;

TimesTen

常见数据库

标签：