Thanks, Paul! I make changes in a couple of places. I rerun query in case of deadlock and there was a problem in generating IDs. I guess it's visible in changes. I'm also not so familar with Java but test looks working to me. I hope it quite usable and I consider any suggestions or questions about it.
I did not fork original sources. I forked from another fork on github. That developer had the same problem. He could not add DB2 support. I can share access to my fork or request reprissions to parent project if my pull request will be accepted. 2015-03-12 14:12 GMT+03:00 Paul Reeves <[email protected]>: > > 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 -- 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
