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. 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. 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.
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.
Take non-audited numbers with a block of salt. VoltDB cheats across the
board (they eliminated a transaction type that could deadlock so they could
run without rollback enabled), publishes completely bogus numbers, and
seems to get away with it.
On Thursday, March 12, 2015, Roman Simakov <[email protected]> wrote:
> Hello!
>
> I've ported BenchmarkSQL for Firebird. It's TPC-C test working via
> JDBC and support PostgreSQL, Oracle, DB2 and now Firebird.
>
> https://github.com/romansimakov/BenchmarkSQL
>
> I could run it locally and maybe it could be useful to know where we
> are comparing to other DBMSs.
>
> Please share you investigations.
>
> --
> Roman Simakov
>
>
> ------------------------------------------------------------------------------
> 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
>
--
Jim Starkey
------------------------------------------------------------------------------
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
