performance - 我们可以期待 kdb+ 32bit 的性能

Question

Kx announced他们的 free kdb+ (32 位)时间序列数据库。

我们通常可以从这个数据库中获得什么样的每秒读/写性能？

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

Answer 1

经过更多调查，我在 kx.com website 上找到了示例性能基准测试。 :

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)

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):

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)