Re: [Firebird-devel] ANN: BenchmarkSQL

2015-03-12 Thread Mark Rotteveel
On 12-3-2015 12:12, Paul Reeves wrote: > 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

Re: [Firebird-devel] ANN: BenchmarkSQL

2015-03-12 Thread Paul Reeves
On Thursday 12 March 2015 13:39:20 Roman Simakov wrote: > 2015-03-12 15:19 GMT+03:00 Paul Reeves : > > 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.

Re: [Firebird-devel] ANN: BenchmarkSQL

2015-03-12 Thread Roman Simakov
2015-03-12 15:19 GMT+03:00 Paul Reeves : > 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. This program generates a stream of queries to server and measures s

Re: [Firebird-devel] ANN: BenchmarkSQL

2015-03-12 Thread Paul Reeves
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

Re: [Firebird-devel] ANN: BenchmarkSQL

2015-03-12 Thread Paul Reeves
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 d

Re: [Firebird-devel] ANN: BenchmarkSQL

2015-03-12 Thread James Starkey
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 wareho

Re: [Firebird-devel] ANN: BenchmarkSQL

2015-03-12 Thread Roman Simakov
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

Re: [Firebird-devel] ANN: BenchmarkSQL

2015-03-12 Thread Paul Reeves
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 use