Breaking the trillion-rows-per-second barrier with MemSQL

Re:Breaking the trillion-rows-per-second barrier with MemSQL by n0tme on Monday March 19, 2018 @06:59AM (#16617469)

Can't talk about MySQL or PostgreSQL, but with Oracle I am pretty sure you can get very much close to this result with cached data. And this is without using the in-memory option. However, talking about it withouth any experiments to prove a point is just speculation. Memory vs Disks changes a lot performance-wise.

[ Parent | on HN ]

Re:Breaking the trillion-rows-per-second barrier with MemSQL by exikyut on Monday March 19, 2018 @07:22AM (#16617585)

It was expressly forbidden in the software contract to benchmark Oracle back in the 80s.

https://danluu.com/anon-benchmark/

[ Parent | on HN ]

Re:Breaking the trillion-rows-per-second barrier with MemSQL by captain_perl on Tuesday March 20, 2018 @11:31PM (#16635169)

It's forbidden to publish the benchmarks, not to make them. And it's because most users are rubes who can't tune 2 databases at the same time.

[ Parent | on HN ]

Re:Breaking the trillion-rows-per-second barrier with MemSQL by olavgg on Monday March 19, 2018 @07:28AM (#16617615)

With the ClickHouse OLAP db I'm limited by memory bandwidth.

[ Parent | on HN ]