On Thursday 12 March 2015 10:25:49 Roman Simakov 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.
I've done a lot of work with BenchmarkSQL although not with v4. But as AFAICT it is largely a refactoring of v2.3 with log4j added, plus the ability to run from the command line rather than from the gui. These are nice changes but don't deal with the fundamental problems. Overall I've had to make quite a few changes to turn it into a useful Firebird benchmarking tool. Unfortunately the refactoring since 2.3 is so great that it is almost impossible to compare my version with the current one. I've mainly reworked it to remove all the lock contention. Some of this contention exists partly by design in the tpc-c spec, but some of it is also due to a misunderstanding of the spec by the original developer. (The BenchmarkSQL guys were not the original developers of the java implementation.) It is interesting that you have worked with JayBird 2.2.n. In my experience it locks up under heavy contention when the terminals try to close down at the end of a session. 2.1.6 doesn't do that. I'm not too sure how to reproduce the problem but as 2.1.6 has always worked for me I've not had the time to study why later versions of JayBird don't work for me. Still, it is good that you have put this under version control - the source has always been available from the sourceforge project, but never in CVS or SVN. By the time I was ready to give them my changes the code had been refactored and as there was no CVS tree there wasn't really anywhere for me to send them. 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
