On Thursday 12 March 2015 12:31:01 James Starkey wrote: > I wouldn't get excited about TPCC / DBT2 either way. It's a remarkably > stupid benchmark designed to show that partioning is the only way to go. > It is full of idiotic assumption and horrible technology.
This is all very true. And it doesn't even exercise the hardware very much. OTOH, this java implementation is quite neat - it is more or less cross-platform out of the box (I praise the architects of JDBC on an almost daily basis.) And it has been, for me at least, a good starting point to develop a test harness. > It assumes, for > example, that everything a customer orders can be serviced from a single > warehouse so it assign order ids by updating a warehouse record. And it updates the year to date sales for each warehouse and each district after every new order. Absolutely insane when txns last a few milliseconds. The value as management information would be useless just a second later. But the contention caused is massive. I started out with this benchmark because I wanted to model firebird under heavy load and had to make a lot of changes to allow that to happen. Pretty much all the r/w workloads have contention problems that are built into the spec. Overall the spec is a fine example of how not to design a database application. > That, of > course, causes a high contention hot spot, the problem that I invented > generators (sequences) to get around a quarter century ago and was part of > the SQL standard before TPCC was designed. Using sequences will have a huge > effect on performance but will violate the terms of the benchmark. And once sequences are used comparisons with other RDBMS become useless, unless they modify their behaviour to use sequences. > If you go that route, use of the term TPC-C violates the terms of the > Transaction Processing Council's trademark which requires an independent > audit. So use the open source alternative, DBT2. Thanks for the correction - I must get into the habit of calling it DBT2. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird ------------------------------------------------------------------------------ Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
