4 ms·
Ask HN: What would be a fair set of database benchmarks?
With the recent discussion around MemSQL vs MySQL vs NoSQL solutions, I've become really curious if their is a 'fair' way to do some sort of comparative testing or benchmarks.
I'm thinking of something like Tim Bray's WideFinder project[1], something practical and straightforward that lots of different people with expertise in different data stores could approach.
1 - http://www.tbray.org/ongoing/When/200x/2007/09/20/Wide-Finder
- kephra 14y agoTPC-A might be the easiest to implement (even if its no longer standard), if you have access to larger pool of client computers, e.g. at an university. The other TPC benchmarks might fit better, but they are difficult to impossible to implement yourself. The (better) alternate might be using your application as a benchmark. But this might show that not the database itself is the bottleneck, but your application framework.
- wmf 14y agoThere's an entire organization dedicated to this: http://tpc.org/ http://tpc.org/