我们可以从kdb + 32bit期待什么性能 [英] What performance can we expect from kdb+ 32bit

问题描述

Kx 宣布他们的

Kx announced their free kdb+ (32bit) time series database.

我们通常可以从该数据库期望每秒读取/写入的性能如何?

What performance in terms of reads/writes per second can we typically expect from this database?

我确实理解这是一个复杂的问题，因为答案取决于设置，节点数等.我希望有人能够为我们提供一些数字以及用例.

I do understand this is a complex question as the answer depends on a setup, number of nodes, etc. I am hoping someone will be able to provide us some numbers as well as use cases.

推荐答案

经过更多调查，我在 kx.com网站:

在具有4 GB RAM的AMD Opteron盒上，我们得到

On an AMD Opteron box with 4 GB of RAM, we get

0.672 million inserts per second (single insert)
6.944 million inserts per second (bulk insert 10)
20.408 million inserts per second (bulk insert 100)
24.39 million inserts per second (bulk insert 1000)
25 million inserts per second (bulk insert 10000)

在具有0.5 GB RAM的AMD Turion64笔记本电脑上，

On an AMD Turion64 laptop with 0.5 GB of RAM,

0.928 million inserts per second (single insert)
8.065 million inserts per second (bulk insert 10)
16.129 million inserts per second (bulk insert 100)
16.129 million inserts per second (bulk insert 1000)
16.129 million inserts per second (bulk insert 10000)

在我的计算机上运行相同的基准测试(32GB RAM，Xeon E5 3.2GHz，SSD):

Running the same benchmarks on my machine (32GB RAM, Xeon E5 3.2GHz, SSD):

1.972 million inserts per second (single insert)
30.303 million inserts per second (bulk insert 10)
142.857 million inserts per second (bulk insert 100)
250 million inserts per second (bulk insert 1000)
200 million inserts per second (bulk insert 10000)

这篇关于我们可以从kdb + 32bit期待什么性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！