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.
After more investigation I found sample performance benchmarks on the 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)
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)