Cassandra 简单测试

简单测试了一下Cassandra的插入和查询性能

 

AMD Athlon(tm) P360 Dual-Core 2.30GHz
RAM 3.25GB
Windows Seven 32bit
Cassandra 1.01, Hector 1.0

Standard CF

insert

1000000 rows, 1 column, bulk of 1000, 69.761s, 14334 cells/s
1000000 rows, 1 column, bulk of 100, 76.688s, 13039 cells/s
1000000 rows, 1 column, bulk of 10, 118.107s, 8466 cells/s
1000000 rows, 1 column, bulk of 1, 469.365s, 2130 cells/s
100000 rows, 1 column, bulk of 1, 43.992s, 2273 cells/s
10000 rows, 1 column, bulk of 1, 4.867s, 2054 cells/s

1 row, 1000000 columns, bulk of 1000, 13.978s, 71540 cells/s
1 row, 1000000 columns, bulk of 100, 18.671s, 53558 cells/s
1 row, 1000000 columns, bulk of 10, 55.895s, 17890 cells/s
1 row, 1000000 columns, bulk of 1, 465.775s, 2146 cells/s
1 row, 100000 columns, bulk of 1, 40.275s, 2482 cells/s
1 row, 10000 columns, bulk of 1, 4.791s, 2087 cells/s

query
10000 rows, 1000 column, query random of 1000 keys:
1 column 2307ms
10 columns 2301ms
100 columns 2739ms
1000 columns 7172ms
(
bulk query
1 column 709ms
10 columns 739ms
100 columns 1524ms
1000 columns 7024ms
)

10000 rows, 100 column, query random of 1000 keys:
1 column 2064ms
10 columns 2130ms
100 columns 2532ms
(
bulk query
1 column 466ms
10 columns 566ms
100 columns 1257ms
)

10000 rows, 10 column, query random of 1000 keys:
1 column
10 columns

10000 rows, 1 column, query random of 1000 keys:
1 column 1110ms

Super CF

insert
1000 rows, 100 super columns, 100 sub columns, bulk of 100, 162.339s 61599 cells/s
1000 rows, 100 super columns, 100 sub columns, bulk of 1000, 130.433s 76667 cells/s
1000 rows, 100 super columns, 100 sub columns, bulk of 10000, 135.420s 73844 cells/s
1000 rows, 100 super columns, 100 sub columns, bulk of 100000, 146.521s 68249 cells/s

1000 rows, 100 super columns, 1 sub columns, bulk of 100, 3.026s 33046 cells/s
1000 rows, 100 super columns, 1 sub columns, bulk of 1000, 2.012s 49701 cells/s
1000 rows, 100 super columns, 1 sub columns, bulk of 10000, 2.547s 39261 cells/s
1000 rows, 100 super columns, 1 sub columns, bulk of 100000, 2.796s 35765 cells/s

query
1000 rows, 100 super columns, 100 sub columns, query random of 1000 keys:
1 super column 2543ms
10 super columns 5545ms
100 super columns 43409ms

(
bulk query
1 super column 969ms
10 super columns 5280ms
100 super columns TimedOutException
)

1000 rows, 100 super columns, 1 sub columns, query random of 1000 keys:
1 super column 1102ms
10 super columns 1167ms
100 super columns 1851ms

(
bulk query
1 super column 164ms
10 super columns 261ms
100 super columns 1221ms
)