On Thursday 12 March 2015 12:22:49 Roman Simakov wrote: > > 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 tried all sorts of things to deal with lock contention but ultimately the only real solution is to remove the underlying problems by re-writing the spec. :-) Otherwise you are stuck with measuring, say, 10 concurrent users. Tat is fine up to a point but I wanted something that could respond to questions such as 'What happens as we add more users?' or 'How does database size impact on performance?' and so on. > 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. The test certainly works - but the results are not too useful, imo. > 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. Sigh! When I last looked I found at least four java based tpc-c benchmark projects. All of them are derived from the same original implementation. If you google some of the exceptions that are raised you will find them pretty quickly. Some of the exception messages just don't make any sense in the context of the exception that is being raised and yet every version of the benchmark repeats the same misunderstanding. It is quite funny really how many people have latched onto this program, found it 'just works' and made a few modifications to it thinking they have a useful benchmarking application. I must admit I was suckered by this myself. I spent a lot of time twiddling with it before I finally sat down and compared the specification to the implementation. Basically between the flaws in the specification and the mistakes in the implementation I have concluded that it really isn't fit for purpose in the format that you have been using. Whether my changes have improved it sufficiently is another matter. I guess it is time for me to see if I can get it out of my private CVS tree and put it on github. Then we can take a look at this subject in more detail. 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
