gmane.comp.apache.db.derby.devel http://blog.gmane.org/gmane.comp.apache.db.derby.devel hourly 1 1901-01-01T00:00+00:00 Gmane http://gmane.org/img/gmane-25t.png http://gmane.org [jira] [Comment Edited] (DERBY-118) Allow any build-in function as default values in table create for columns http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95674 <pre> [ https://issues.apache.org/jira/browse/DERBY-118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&amp;focusedCommentId=13282025#comment-13282025 ] Dag H. Wanvik edited comment on DERBY-118 at 5/23/12 11:12 PM: --------------------------------------------------------------- Looking at the standard, I see that the default value is defined as &lt;default option&gt; ::= &lt;literal&gt; | &lt;datetime value function&gt; | USER | CURRENT_USER | CURRENT_ROLE | SESSION_USER | SYSTEM_USER | CURRENT_PATH | &lt;implicitly typed value specification&gt; This would seem to preclude a cast in the form of CHAR(CURRENT_DATE), but this would be ok: CREATE TABLE ok (create_date_string VARCHAR(40) DEFAULT CURRENT_DATE) and similarly for CURRENT_TIME and CURRENT_TIMESTAMP - it doesn't currently. We do allow this implicit coercion on INSERT. Uploading a proof-of-concept patch which makes the above table creation work: derby-118.diff. No tests yet, running regressions. was (Author: dagw): Looking at the standard, I see that the default value is defined as &lt;default option&gt; ::= &lt;literal&gt; | &lt;datetime value function&gt; | USER | CURRENT_USER | CURRENT_ROLE | SESSION_USER | SYSTEM_USER | CURRENT_PATH | &lt;implicitly typed value specification&gt; This would seem to preclude a cast in the form of CHAR(CURRENT_DATE), but this would be ok: CREATE TABLE ok (create_date_string VARCHAR(40) DEFAULT CURRENT_DATE) and similarly for CURRENT_TIME and CURRENT_TIMESTAMP. We do allow this implicit coercion on INSERT. Uploading a proof-of-concept patch which makes the above table creation work: derby-118.diff. No tests yet, running regressions. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Dag H. Wanvik (JIRA 2012-05-23T23:13:40 [jira] [Assigned] (DERBY-118) Allow any build-in function as default values in table create for columns http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95673 <pre> [ https://issues.apache.org/jira/browse/DERBY-118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dag H. Wanvik reassigned DERBY-118: ----------------------------------- Assignee: Dag H. Wanvik -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Dag H. Wanvik (JIRA 2012-05-23T23:13:40 [jira] [Commented] (DERBY-118) Allow any build-in function as default values in table create for columns http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95672 <pre> [ https://issues.apache.org/jira/browse/DERBY-118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&amp;focusedCommentId=13282025#comment-13282025 ] Dag H. Wanvik commented on DERBY-118: ------------------------------------- Looking at the standard, I see that the default value is defined as &lt;default option&gt; ::= &lt;literal&gt; | &lt;datetime value function&gt; | USER | CURRENT_USER | CURRENT_ROLE | SESSION_USER | SYSTEM_USER | CURRENT_PATH | &lt;implicitly typed value specification&gt; This would seem to preclude a cast in the form of CHAR(CURRENT_DATE), but this would be ok: CREATE TABLE ok (create_date_string VARCHAR(40) DEFAULT CURRENT_DATE) and similarly for CURRENT_TIME and CURRENT_TIMESTAMP. We do allow this implicit coercion on INSERT. Uploading a proof-of-concept patch which makes the above table creation work: derby-118.diff. No tests yet, running regressions. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Dag H. Wanvik (JIRA 2012-05-23T23:11:41 [jira] [Updated] (DERBY-118) Allow any build-in function as default values in table create for columns http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95671 <pre> [ https://issues.apache.org/jira/browse/DERBY-118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dag H. Wanvik updated DERBY-118: -------------------------------- Attachment: derby-118.stat derby-118.diff -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Dag H. Wanvik (JIRA 2012-05-23T23:11:41 [jira] [Commented] (DERBY-5471) Stress test for identity columns and sequence seem to be taking longer on trunk compared to 10.8.2.2 RC3 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95670 <pre> [ https://issues.apache.org/jira/browse/DERBY-5471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&amp;focusedCommentId=13282020#comment-13282020 ] Mamta A. Satoor commented on DERBY-5471: ---------------------------------------- Hi Rick, yes I posted more results with revision right before DERBY-5494 changes and with revision at which DERBY-5494 changes went in. I have posted those results new jira DERBY-5780. Note through that I ran all these tests with Enable write caching on the device AND Turn off Windows write-cache buffer flushing on the device. I am going to turn off these settings and rerun my tests on 10.8.2.2 and trunk and see what behavior we see. I will post the test results to DERBY-5780. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Mamta A. Satoor (JIRA 2012-05-23T23:03:40 [jira] [Updated] (DERBY-5780) identity column performance has degredated http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95669 <pre> [ https://issues.apache.org/jira/browse/DERBY-5780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mamta A. Satoor updated DERBY-5780: ----------------------------------- Description: Mamta has run some performance tests on windows, with (Enable write caching on the device AND Turn off Windows write-cache buffer flushing on the device) that shows performance degredation of identity columns. See results posted in DERBY-5471, copied here: Rick, first of all, I want to apologize for not responding to this jira sooner. I allowed other jiras to prioritize over this but I finally got around to running a long set of tests and here are the results of them. I have truned off debugging prints in these test runs. I ran lots of test as explained below on released 10.8.2.2 jars and top of the trunk(revision 1341151) insane jars with write caching off and the test results between the 2 set of jars do vary. I have Windows7 service pack1 laptop(Intel(R) Core(TM) i7-2720QM CPU &lt; at &gt;2.20GHz, 8GB RAM) with IBM jdk 1.6 I chose to run with preallocation sizes of 5 and 20 because I think the default preallocation for 10.8 is 5 and for trunk is 20. Variations of test(with 3 test runs of each on 10.8 and trunk jars) 1)Identity column 10 threads with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 10630 Average throughput (tx/s): 177.16666666666666 15427 successful transactions, including warmup phase. Test run 2) Number of transactions: 10432 Average throughput (tx/s): 173.86376893718437 15282 successful transactions, including warmup phase. Test run 3) Number of transactions: 10377 Average throughput (tx/s): 172.89524983755143 14908 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 3002 Average throughput (tx/s): 50.021661612290465 4542 successful transactions, including warmup phase. Test run 2) Number of transactions: 2924 Average throughput (tx/s): 48.733333333333334 4370 successful transactions, including warmup phase. Test run 3) Number of transactions: 2547 Average throughput (tx/s): 42.45 4023 successful transactions, including warmup phase. 2)Identity column 10 threads with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 10677 Average throughput (tx/s): 177.92627649646712 15222 successful transactions, including warmup phase. Test run 2) Number of transactions: 11188 Average throughput (tx/s): 186.46355894068432 15744 successful transactions, including warmup phase. Test run 3) Number of transactions: 10571 Average throughput (tx/s): 176.18039699338345 15012 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 2453 Average throughput (tx/s): 40.88333333333333 3716 successful transactions, including warmup phase. Test run 2) Number of transactions: 2531 Average throughput (tx/s): 42.18333333333333 3668 successful transactions, including warmup phase. Test run 3) Number of transactions: 3076 Average throughput (tx/s): 51.266666666666666 4615 successful transactions, including warmup phase. 3)Identity column 1 thread with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 5865 Average throughput (tx/s): 97.75 8773 successful transactions, including warmup phase. Test run 2) Number of transactions: 5753 Average throughput (tx/s): 95.88173530441159 8359 successful transactions, including warmup phase. Test run 3) Number of transactions: 6326 Average throughput (tx/s): 105.43333333333334 9231 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 526 Average throughput (tx/s): 8.766666666666667 801 successful transactions, including warmup phase. Test run 2) Number of transactions: 546 Average throughput (tx/s): 9.1 831 successful transactions, including warmup phase. Test run 3) Number of transactions: 572 Average throughput (tx/s): 9.533174447092549 841 successful transactions, including warmup phase. 4)Identity column 1 thread with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 5948 Average throughput (tx/s): 99.13333333333334 8799 successful transactions, including warmup phase. Test run 2) Number of transactions: 5658 Average throughput (tx/s): 94.3 8337 successful transactions, including warmup phase. Test run 3) Number of transactions: 6314 Average throughput (tx/s): 105.21755070072822 9197 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 470 Average throughput (tx/s): 7.833202779953668 737 successful transactions, including warmup phase. Test run 2) Number of transactions: 548 Average throughput (tx/s): 9.133333333333333 814 successful transactions, including warmup phase. Test run 3) Number of transactions: 559 Average throughput (tx/s): 9.315424610051993 851 successful transactions, including warmup phase. 5)Sequence column 10 threads with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 20978 Average throughput (tx/s): 349.6275062082299 31469 successful transactions, including warmup phase. Test run 2) Number of transactions: 20496 Average throughput (tx/s): 341.6 30196 successful transactions, including warmup phase. Test run 3) Number of transactions: 17433 Average throughput (tx/s): 290.545157580707 24772 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 470 Average throughput (tx/s): 7.833202779953668 737 successful transactions, including warmup phase. Test run 2) Number of transactions: 548 Average throughput (tx/s): 9.133333333333333 814 successful transactions, including warmup phase. Test run 3) Number of transactions: 559 Average throughput (tx/s): 9.315424610051993 851 successful transactions, including warmup phase. 6)Sequence column 10 threads with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 19927 Average throughput (tx/s): 332.11113148114197 30250 successful transactions, including warmup phase. Test run 2) Number of transactions: 21048 Average throughput (tx/s): 350.8 31331 successful transactions, including warmup phase. Test run 3) Number of transactions: 20707 Average throughput (tx/s): 345.1166666666667 30251 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 7038 Average throughput (tx/s): 117.29804503258279 13041 successful transactions, including warmup phase. Test run 2) Number of transactions: 10129 Average throughput (tx/s): 168.8138531024483 15210 successful transactions, including warmup phase. Test run 3) Number of transactions: 13775 Average throughput (tx/s): 229.58333333333334 19609 successful transactions, including warmup phase. 7)Sequence column 1 thread with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 12989 Average throughput (tx/s): 216.47972533791105 19048 successful transactions, including warmup phase. Test run 2) Number of transactions: 12521 Average throughput (tx/s): 208.68333333333334 18560 successful transactions, including warmup phase. Test run 3) Number of transactions: 11970 Average throughput (tx/s): 199.5 17763 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 6853 Average throughput (tx/s): 114.21476308728188 10286 successful transactions, including warmup phase. Test run 2) Number of transactions: 7277 Average throughput (tx/s): 121.2813119781337 10733 successful transactions, including warmup phase. Test run 3) Number of transactions: 7293 Average throughput (tx/s): 121.55 10772 successful transactions, including warmup phase. 8)Sequence column 1 thread with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 12059 Average throughput (tx/s): 200.93979637745156 17215 successful transactions, including warmup phase. Test run 2) Number of transactions: 11071 Average throughput (tx/s): 184.51359144014268 16884 successful transactions, including warmup phase. Test run 3) Number of transactions: 12073 Average throughput (tx/s): 201.21331311144814 17489 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 2479 Average throughput (tx/s): 41.31597806703222 3673 successful transactions, including warmup phase. Test run 2) Number of transactions: 2657 Average throughput (tx/s): 44.2825952900785 3921 successful transactions, including warmup phase. Test run 3) Number of transactions: 2518 Average throughput (tx/s): 41.96596723387943 3698 successful transactions, including warmup phase. was: Mamta has run some performance tests on windows, with write cache disabled that shows performance degredation of identity columns. See results posted in DERBY-5471, copied here: Rick, first of all, I want to apologize for not responding to this jira sooner. I allowed other jiras to prioritize over this but I finally got around to running a long set of tests and here are the results of them. I have truned off debugging prints in these test runs. I ran lots of test as explained below on released 10.8.2.2 jars and top of the trunk(revision 1341151) insane jars with write caching off and the test results between the 2 set of jars do vary. I have Windows7 service pack1 laptop(Intel(R) Core(TM) i7-2720QM CPU &lt; at &gt;2.20GHz, 8GB RAM) with IBM jdk 1.6 I chose to run with preallocation sizes of 5 and 20 because I think the default preallocation for 10.8 is 5 and for trunk is 20. Variations of test(with 3 test runs of each on 10.8 and trunk jars) 1)Identity column 10 threads with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 10630 Average throughput (tx/s): 177.16666666666666 15427 successful transactions, including warmup phase. Test run 2) Number of transactions: 10432 Average throughput (tx/s): 173.86376893718437 15282 successful transactions, including warmup phase. Test run 3) Number of transactions: 10377 Average throughput (tx/s): 172.89524983755143 14908 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 3002 Average throughput (tx/s): 50.021661612290465 4542 successful transactions, including warmup phase. Test run 2) Number of transactions: 2924 Average throughput (tx/s): 48.733333333333334 4370 successful transactions, including warmup phase. Test run 3) Number of transactions: 2547 Average throughput (tx/s): 42.45 4023 successful transactions, including warmup phase. 2)Identity column 10 threads with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 10677 Average throughput (tx/s): 177.92627649646712 15222 successful transactions, including warmup phase. Test run 2) Number of transactions: 11188 Average throughput (tx/s): 186.46355894068432 15744 successful transactions, including warmup phase. Test run 3) Number of transactions: 10571 Average throughput (tx/s): 176.18039699338345 15012 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 2453 Average throughput (tx/s): 40.88333333333333 3716 successful transactions, including warmup phase. Test run 2) Number of transactions: 2531 Average throughput (tx/s): 42.18333333333333 3668 successful transactions, including warmup phase. Test run 3) Number of transactions: 3076 Average throughput (tx/s): 51.266666666666666 4615 successful transactions, including warmup phase. 3)Identity column 1 thread with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 5865 Average throughput (tx/s): 97.75 8773 successful transactions, including warmup phase. Test run 2) Number of transactions: 5753 Average throughput (tx/s): 95.88173530441159 8359 successful transactions, including warmup phase. Test run 3) Number of transactions: 6326 Average throughput (tx/s): 105.43333333333334 9231 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 526 Average throughput (tx/s): 8.766666666666667 801 successful transactions, including warmup phase. Test run 2) Number of transactions: 546 Average throughput (tx/s): 9.1 831 successful transactions, including warmup phase. Test run 3) Number of transactions: 572 Average throughput (tx/s): 9.533174447092549 841 successful transactions, including warmup phase. 4)Identity column 1 thread with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 5948 Average throughput (tx/s): 99.13333333333334 8799 successful transactions, including warmup phase. Test run 2) Number of transactions: 5658 Average throughput (tx/s): 94.3 8337 successful transactions, including warmup phase. Test run 3) Number of transactions: 6314 Average throughput (tx/s): 105.21755070072822 9197 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 470 Average throughput (tx/s): 7.833202779953668 737 successful transactions, including warmup phase. Test run 2) Number of transactions: 548 Average throughput (tx/s): 9.133333333333333 814 successful transactions, including warmup phase. Test run 3) Number of transactions: 559 Average throughput (tx/s): 9.315424610051993 851 successful transactions, including warmup phase. 5)Sequence column 10 threads with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 20978 Average throughput (tx/s): 349.6275062082299 31469 successful transactions, including warmup phase. Test run 2) Number of transactions: 20496 Average throughput (tx/s): 341.6 30196 successful transactions, including warmup phase. Test run 3) Number of transactions: 17433 Average throughput (tx/s): 290.545157580707 24772 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 470 Average throughput (tx/s): 7.833202779953668 737 successful transactions, including warmup phase. Test run 2) Number of transactions: 548 Average throughput (tx/s): 9.133333333333333 814 successful transactions, including warmup phase. Test run 3) Number of transactions: 559 Average throughput (tx/s): 9.315424610051993 851 successful transactions, including warmup phase. 6)Sequence column 10 threads with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 19927 Average throughput (tx/s): 332.11113148114197 30250 successful transactions, including warmup phase. Test run 2) Number of transactions: 21048 Average throughput (tx/s): 350.8 31331 successful transactions, including warmup phase. Test run 3) Number of transactions: 20707 Average throughput (tx/s): 345.1166666666667 30251 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 7038 Average throughput (tx/s): 117.29804503258279 13041 successful transactions, including warmup phase. Test run 2) Number of transactions: 10129 Average throughput (tx/s): 168.8138531024483 15210 successful transactions, including warmup phase. Test run 3) Number of transactions: 13775 Average throughput (tx/s): 229.58333333333334 19609 successful transactions, including warmup phase. 7)Sequence column 1 thread with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 12989 Average throughput (tx/s): 216.47972533791105 19048 successful transactions, including warmup phase. Test run 2) Number of transactions: 12521 Average throughput (tx/s): 208.68333333333334 18560 successful transactions, including warmup phase. Test run 3) Number of transactions: 11970 Average throughput (tx/s): 199.5 17763 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 6853 Average throughput (tx/s): 114.21476308728188 10286 successful transactions, including warmup phase. Test run 2) Number of transactions: 7277 Average throughput (tx/s): 121.2813119781337 10733 successful transactions, including warmup phase. Test run 3) Number of transactions: 7293 Average throughput (tx/s): 121.55 10772 successful transactions, including warmup phase. 8)Sequence column 1 thread with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 12059 Average throughput (tx/s): 200.93979637745156 17215 successful transactions, including warmup phase. Test run 2) Number of transactions: 11071 Average throughput (tx/s): 184.51359144014268 16884 successful transactions, including warmup phase. Test run 3) Number of transactions: 12073 Average throughput (tx/s): 201.21331311144814 17489 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 2479 Average throughput (tx/s): 41.31597806703222 3673 successful transactions, including warmup phase. Test run 2) Number of transactions: 2657 Average throughput (tx/s): 44.2825952900785 3921 successful transactions, including warmup phase. Test run 3) Number of transactions: 2518 Average throughput (tx/s): 41.96596723387943 3698 successful transactions, including warmup phase. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Mamta A. Satoor (JIRA 2012-05-23T23:01:41 [jira] [Comment Edited] (DERBY-5471) Stress test for identity columns and sequence seem to be taking longer on trunk compared to 10.8.2.2 RC3 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95668 <pre> [ https://issues.apache.org/jira/browse/DERBY-5471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&amp;focusedCommentId=13281820#comment-13281820 ] Mamta A. Satoor edited comment on DERBY-5471 at 5/23/12 10:55 PM: ------------------------------------------------------------------ Rick, first of all, I want to apologize for not responding to this jira sooner. I allowed other jiras to prioritize over this but I finally got around to running a long set of tests and here are the results of them. I have truned off debugging prints in these test runs. I ran lots of test as explained below on released 10.8.2.2 jars and top of the trunk(revision 1341151) insane jars with (Enable write caching on the device AND Turn off Windows write-cache buffer flushing on the device) and the test results between the 2 set of jars do vary. I have Windows7 service pack1 laptop(Intel(R) Core(TM) i7-2720QM CPU &lt; at &gt;2.20GHz, 8GB RAM) with IBM jdk 1.6 I chose to run with preallocation sizes of 5 and 20 because I think the default preallocation for 10.8 is 5 and for trunk is 20. Variations of test(with 3 test runs of each on 10.8 and trunk jars) 1)Identity column 10 threads with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 10630 Average throughput (tx/s): 177.16666666666666 15427 successful transactions, including warmup phase. Test run 2) Number of transactions: 10432 Average throughput (tx/s): 173.86376893718437 15282 successful transactions, including warmup phase. Test run 3) Number of transactions: 10377 Average throughput (tx/s): 172.89524983755143 14908 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 3002 Average throughput (tx/s): 50.021661612290465 4542 successful transactions, including warmup phase. Test run 2) Number of transactions: 2924 Average throughput (tx/s): 48.733333333333334 4370 successful transactions, including warmup phase. Test run 3) Number of transactions: 2547 Average throughput (tx/s): 42.45 4023 successful transactions, including warmup phase. 2)Identity column 10 threads with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 10677 Average throughput (tx/s): 177.92627649646712 15222 successful transactions, including warmup phase. Test run 2) Number of transactions: 11188 Average throughput (tx/s): 186.46355894068432 15744 successful transactions, including warmup phase. Test run 3) Number of transactions: 10571 Average throughput (tx/s): 176.18039699338345 15012 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 2453 Average throughput (tx/s): 40.88333333333333 3716 successful transactions, including warmup phase. Test run 2) Number of transactions: 2531 Average throughput (tx/s): 42.18333333333333 3668 successful transactions, including warmup phase. Test run 3) Number of transactions: 3076 Average throughput (tx/s): 51.266666666666666 4615 successful transactions, including warmup phase. 3)Identity column 1 thread with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 5865 Average throughput (tx/s): 97.75 8773 successful transactions, including warmup phase. Test run 2) Number of transactions: 5753 Average throughput (tx/s): 95.88173530441159 8359 successful transactions, including warmup phase. Test run 3) Number of transactions: 6326 Average throughput (tx/s): 105.43333333333334 9231 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 526 Average throughput (tx/s): 8.766666666666667 801 successful transactions, including warmup phase. Test run 2) Number of transactions: 546 Average throughput (tx/s): 9.1 831 successful transactions, including warmup phase. Test run 3) Number of transactions: 572 Average throughput (tx/s): 9.533174447092549 841 successful transactions, including warmup phase. 4)Identity column 1 thread with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 5948 Average throughput (tx/s): 99.13333333333334 8799 successful transactions, including warmup phase. Test run 2) Number of transactions: 5658 Average throughput (tx/s): 94.3 8337 successful transactions, including warmup phase. Test run 3) Number of transactions: 6314 Average throughput (tx/s): 105.21755070072822 9197 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 470 Average throughput (tx/s): 7.833202779953668 737 successful transactions, including warmup phase. Test run 2) Number of transactions: 548 Average throughput (tx/s): 9.133333333333333 814 successful transactions, including warmup phase. Test run 3) Number of transactions: 559 Average throughput (tx/s): 9.315424610051993 851 successful transactions, including warmup phase. 5)Sequence column 10 threads with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 20978 Average throughput (tx/s): 349.6275062082299 31469 successful transactions, including warmup phase. Test run 2) Number of transactions: 20496 Average throughput (tx/s): 341.6 30196 successful transactions, including warmup phase. Test run 3) Number of transactions: 17433 Average throughput (tx/s): 290.545157580707 24772 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 470 Average throughput (tx/s): 7.833202779953668 737 successful transactions, including warmup phase. Test run 2) Number of transactions: 548 Average throughput (tx/s): 9.133333333333333 814 successful transactions, including warmup phase. Test run 3) Number of transactions: 559 Average throughput (tx/s): 9.315424610051993 851 successful transactions, including warmup phase. 6)Sequence column 10 threads with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 19927 Average throughput (tx/s): 332.11113148114197 30250 successful transactions, including warmup phase. Test run 2) Number of transactions: 21048 Average throughput (tx/s): 350.8 31331 successful transactions, including warmup phase. Test run 3) Number of transactions: 20707 Average throughput (tx/s): 345.1166666666667 30251 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 7038 Average throughput (tx/s): 117.29804503258279 13041 successful transactions, including warmup phase. Test run 2) Number of transactions: 10129 Average throughput (tx/s): 168.8138531024483 15210 successful transactions, including warmup phase. Test run 3) Number of transactions: 13775 Average throughput (tx/s): 229.58333333333334 19609 successful transactions, including warmup phase. 7)Sequence column 1 thread with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 12989 Average throughput (tx/s): 216.47972533791105 19048 successful transactions, including warmup phase. Test run 2) Number of transactions: 12521 Average throughput (tx/s): 208.68333333333334 18560 successful transactions, including warmup phase. Test run 3) Number of transactions: 11970 Average throughput (tx/s): 199.5 17763 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 6853 Average throughput (tx/s): 114.21476308728188 10286 successful transactions, including warmup phase. Test run 2) Number of transactions: 7277 Average throughput (tx/s): 121.2813119781337 10733 successful transactions, including warmup phase. Test run 3) Number of transactions: 7293 Average throughput (tx/s): 121.55 10772 successful transactions, including warmup phase. 8)Sequence column 1 thread with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 12059 Average throughput (tx/s): 200.93979637745156 17215 successful transactions, including warmup phase. Test run 2) Number of transactions: 11071 Average throughput (tx/s): 184.51359144014268 16884 successful transactions, including warmup phase. Test run 3) Number of transactions: 12073 Average throughput (tx/s): 201.21331311144814 17489 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 2479 Average throughput (tx/s): 41.31597806703222 3673 successful transactions, including warmup phase. Test run 2) Number of transactions: 2657 Average throughput (tx/s): 44.2825952900785 3921 successful transactions, including warmup phase. Test run 3) Number of transactions: 2518 Average throughput (tx/s): 41.96596723387943 3698 successful transactions, including warmup phase. was (Author: mamtas): Rick, first of all, I want to apologize for not responding to this jira sooner. I allowed other jiras to prioritize over this but I finally got around to running a long set of tests and here are the results of them. I have truned off debugging prints in these test runs. I ran lots of test as explained below on released 10.8.2.2 jars and top of the trunk(revision 1341151) insane jars with write caching off and the test results between the 2 set of jars do vary. I have Windows7 service pack1 laptop(Intel(R) Core(TM) i7-2720QM CPU &lt; at &gt;2.20GHz, 8GB RAM) with IBM jdk 1.6 I chose to run with preallocation sizes of 5 and 20 because I think the default preallocation for 10.8 is 5 and for trunk is 20. Variations of test(with 3 test runs of each on 10.8 and trunk jars) 1)Identity column 10 threads with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 10630 Average throughput (tx/s): 177.16666666666666 15427 successful transactions, including warmup phase. Test run 2) Number of transactions: 10432 Average throughput (tx/s): 173.86376893718437 15282 successful transactions, including warmup phase. Test run 3) Number of transactions: 10377 Average throughput (tx/s): 172.89524983755143 14908 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 3002 Average throughput (tx/s): 50.021661612290465 4542 successful transactions, including warmup phase. Test run 2) Number of transactions: 2924 Average throughput (tx/s): 48.733333333333334 4370 successful transactions, including warmup phase. Test run 3) Number of transactions: 2547 Average throughput (tx/s): 42.45 4023 successful transactions, including warmup phase. 2)Identity column 10 threads with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 10677 Average throughput (tx/s): 177.92627649646712 15222 successful transactions, including warmup phase. Test run 2) Number of transactions: 11188 Average throughput (tx/s): 186.46355894068432 15744 successful transactions, including warmup phase. Test run 3) Number of transactions: 10571 Average throughput (tx/s): 176.18039699338345 15012 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 2453 Average throughput (tx/s): 40.88333333333333 3716 successful transactions, including warmup phase. Test run 2) Number of transactions: 2531 Average throughput (tx/s): 42.18333333333333 3668 successful transactions, including warmup phase. Test run 3) Number of transactions: 3076 Average throughput (tx/s): 51.266666666666666 4615 successful transactions, including warmup phase. 3)Identity column 1 thread with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 5865 Average throughput (tx/s): 97.75 8773 successful transactions, including warmup phase. Test run 2) Number of transactions: 5753 Average throughput (tx/s): 95.88173530441159 8359 successful transactions, including warmup phase. Test run 3) Number of transactions: 6326 Average throughput (tx/s): 105.43333333333334 9231 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 526 Average throughput (tx/s): 8.766666666666667 801 successful transactions, including warmup phase. Test run 2) Number of transactions: 546 Average throughput (tx/s): 9.1 831 successful transactions, including warmup phase. Test run 3) Number of transactions: 572 Average throughput (tx/s): 9.533174447092549 841 successful transactions, including warmup phase. 4)Identity column 1 thread with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 5948 Average throughput (tx/s): 99.13333333333334 8799 successful transactions, including warmup phase. Test run 2) Number of transactions: 5658 Average throughput (tx/s): 94.3 8337 successful transactions, including warmup phase. Test run 3) Number of transactions: 6314 Average throughput (tx/s): 105.21755070072822 9197 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 470 Average throughput (tx/s): 7.833202779953668 737 successful transactions, including warmup phase. Test run 2) Number of transactions: 548 Average throughput (tx/s): 9.133333333333333 814 successful transactions, including warmup phase. Test run 3) Number of transactions: 559 Average throughput (tx/s): 9.315424610051993 851 successful transactions, including warmup phase. 5)Sequence column 10 threads with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 20978 Average throughput (tx/s): 349.6275062082299 31469 successful transactions, including warmup phase. Test run 2) Number of transactions: 20496 Average throughput (tx/s): 341.6 30196 successful transactions, including warmup phase. Test run 3) Number of transactions: 17433 Average throughput (tx/s): 290.545157580707 24772 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 470 Average throughput (tx/s): 7.833202779953668 737 successful transactions, including warmup phase. Test run 2) Number of transactions: 548 Average throughput (tx/s): 9.133333333333333 814 successful transactions, including warmup phase. Test run 3) Number of transactions: 559 Average throughput (tx/s): 9.315424610051993 851 successful transactions, including warmup phase. 6)Sequence column 10 threads with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 19927 Average throughput (tx/s): 332.11113148114197 30250 successful transactions, including warmup phase. Test run 2) Number of transactions: 21048 Average throughput (tx/s): 350.8 31331 successful transactions, including warmup phase. Test run 3) Number of transactions: 20707 Average throughput (tx/s): 345.1166666666667 30251 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 7038 Average throughput (tx/s): 117.29804503258279 13041 successful transactions, including warmup phase. Test run 2) Number of transactions: 10129 Average throughput (tx/s): 168.8138531024483 15210 successful transactions, including warmup phase. Test run 3) Number of transactions: 13775 Average throughput (tx/s): 229.58333333333334 19609 successful transactions, including warmup phase. 7)Sequence column 1 thread with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 12989 Average throughput (tx/s): 216.47972533791105 19048 successful transactions, including warmup phase. Test run 2) Number of transactions: 12521 Average throughput (tx/s): 208.68333333333334 18560 successful transactions, including warmup phase. Test run 3) Number of transactions: 11970 Average throughput (tx/s): 199.5 17763 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 6853 Average throughput (tx/s): 114.21476308728188 10286 successful transactions, including warmup phase. Test run 2) Number of transactions: 7277 Average throughput (tx/s): 121.2813119781337 10733 successful transactions, including warmup phase. Test run 3) Number of transactions: 7293 Average throughput (tx/s): 121.55 10772 successful transactions, including warmup phase. 8)Sequence column 1 thread with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 12059 Average throughput (tx/s): 200.93979637745156 17215 successful transactions, including warmup phase. Test run 2) Number of transactions: 11071 Average throughput (tx/s): 184.51359144014268 16884 successful transactions, including warmup phase. Test run 3) Number of transactions: 12073 Average throughput (tx/s): 201.21331311144814 17489 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 2479 Average throughput (tx/s): 41.31597806703222 3673 successful transactions, including warmup phase. Test run 2) Number of transactions: 2657 Average throughput (tx/s): 44.2825952900785 3921 successful transactions, including warmup phase. Test run 3) Number of transactions: 2518 Average throughput (tx/s): 41.96596723387943 3698 successful transactions, including warmup phase. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Mamta A. Satoor (JIRA 2012-05-23T22:55:46 10.9 update http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95667 <pre>I have created a 10.9 branch and built a release candidate. However, I do not expect to publish this candidate. Some late-breaking performance measurements show a large, unexpected throughput drop for concurrent users of identity columns. See DERBY-5471 and DERBY-5780. It is likely that we will want to address this regression before producing a new release. The fix, of course, will have to be ported to 10.9 now that the branch has been created. Please stand by... Thanks, -Rick </pre> Rick Hillegas 2012-05-23T22:52:35 [jira] [Commented] (DERBY-5471) Stress test for identity columns and sequence seem to be taking longer on trunk compared to 10.8.2.2 RC3 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95666 <pre> [ https://issues.apache.org/jira/browse/DERBY-5471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&amp;focusedCommentId=13282001#comment-13282001 ] Rick Hillegas commented on DERBY-5471: -------------------------------------- Thanks for continuing to test the performance of sequences and identity columns, Mamta. Note that the default size of the pre-allocation range in 10.9 is 100, not 20. We had to boost the pre-allocation size in order to compensate for the throughput drop introduced by DERBY-5494. The pre-allocation size was boosted by patch derby-5493-02-aa-boostPreallocationTo100.diff, attached to DERBY-5493. You should re-run your sequence tests on 10.9 (or the 10.10 trunk) with a pre-allocation size of 100. Note also that pre-allocation for identity columns was backed out of 10.9 by patch derby-5687-01-aa-backOutImprovement.diff, attached to DERBY-5687. Adjusting the size of the pre-allocation range should not affect the throughput of identity columns. Your results confirm this. Note also that 5471-performance.html was attached on 2012-04-17, a couple hours before Mike committed the work on DERBY-5494. The results in 5471-performance.html confirm that identity columns had identical throughput on 10.8.2 and on the trunk BEFORE Mike committed the DERBY-5494 work. Your tests measured performance degradation of identity columns AFTER Mike's fix, although we can't say yet how much of that degradation was due to DERBY-5494 and how much might be attributed to other changes on the trunk since then. In order to tease out that information, you might want to run your experiments on the trunk with DERBY-5494 backed out. Hope this helps, -Rick -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Rick Hillegas (JIRA 2012-05-23T22:40:41 [jira] [Commented] (DERBY-5780) identity column performance has degredated http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95665 <pre> [ https://issues.apache.org/jira/browse/DERBY-5780?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&amp;focusedCommentId=13281976#comment-13281976 ] Mamta A. Satoor commented on DERBY-5780: ---------------------------------------- Just wanted to post some more test results for identity columns. I am testing identity columns with preallocation of 5 and with one thread as shown below java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 1 The result ot this test on 10.8.2.2 Test run 1) Number of transactions: 5948 Average throughput (tx/s): 99.13333333333334 8799 successful transactions, including warmup phase. Test run 2) Number of transactions: 5658 Average throughput (tx/s): 94.3 8337 successful transactions, including warmup phase. Test run 3) Number of transactions: 6314 Average throughput (tx/s): 105.21755070072822 9197 successful transactions, including warmup phase. The results at the top of trunk Test run 1) Number of transactions: 470 Average throughput (tx/s): 7.833202779953668 737 successful transactions, including warmup phase. Test run 2) Number of transactions: 548 Average throughput (tx/s): 9.133333333333333 814 successful transactions, including warmup phase. Test run 3) Number of transactions: 559 Average throughput (tx/s): 9.315424610051993 851 successful transactions, including warmup phase. The results at the revision(1327218) where changes were committed for DERBY-5494 Test run 1) Number of transactions: 606 Average throughput (tx/s): 10.099831669472175 921 successful transactions, including warmup phase. Test run 2) Number of transactions: 603 Average throughput (tx/s): 10.04983250279162 909 successful transactions, including warmup phase. Test run 3) Number of transactions: 563 Average throughput (tx/s): 9.383333333333333 882 successful transactions, including warmup phase. The results right before changes were committed for DERBY-5494. The revision number I believe is 1327050 Test run 1) Number of transactions: 5913 Average throughput (tx/s): 98.32058530096441 8666 successful transactions, including warmup phase. Test run 2) Number of transactions: 6290 Average throughput (tx/s): 104.831586140231 9305 successful transactions, including warmup phase. Test run 3) Number of transactions: 6676 Average throughput (tx/s): 111.26666666666667 9872 successful transactions, including warmup phase. Atleast from this set of tests, it looks like performance degraded after the checkin for DERBY-5494 was made. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Mamta A. Satoor (JIRA 2012-05-23T22:11:41 [jira] [Commented] (DERBY-5780) identity column performance has degredated http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95664 <pre> [ https://issues.apache.org/jira/browse/DERBY-5780?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&amp;focusedCommentId=13281952#comment-13281952 ] Rick Hillegas commented on DERBY-5780: -------------------------------------- I am in the middle of building the first 10.9 release candidate and this issue just turned up with priority Blocker. Since there is some confusion about the difference between priority and urgency, I need to ask this question: Are you flagging this issue as an issue which should block the 10.9 release until we understand the results you are seeing? Thanks. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Rick Hillegas (JIRA 2012-05-23T21:51:41 [jira] [Updated] (DERBY-5688) Track tasks needed to produce the 10.9.1 release http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95663 <pre> [ https://issues.apache.org/jira/browse/DERBY-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-5688: --------------------------------- Attachment: derby-5688-03-aa-statusAndReleaseNotes.diff Attaching derby-5688-03-aa-statusAndReleaseNotes.diff. This updates the STATUS file and the release notes in the 10.9 branch. Committed at subversion revision 1342064. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Rick Hillegas (JIRA 2012-05-23T21:37:40 [jira] [Commented] (DERBY-5494) Same value returned by successive calls to a sequence generator flanking an unorderly shutdown. http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95662 <pre> [ https://issues.apache.org/jira/browse/DERBY-5494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&amp;focusedCommentId=13281933#comment-13281933 ] Mike Matrigali commented on DERBY-5494: --------------------------------------- i do not think we should backport this change until DERBY-5780 is understood. Even then I am still leaning toward not backporting any sequence/identity changes in this area. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Mike Matrigali (JIRA 2012-05-23T21:35:41 [jira] [Created] (DERBY-5780) identity column performance has degredated http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95661 <pre>Mike Matrigali created DERBY-5780: ------------------------------------- Summary: identity column performance has degredated Key: DERBY-5780 URL: https://issues.apache.org/jira/browse/DERBY-5780 Project: Derby Issue Type: Bug Components: Store Affects Versions: 10.10.0.0 Reporter: Mike Matrigali Assignee: Mike Matrigali Priority: Blocker Mamta has run some performance tests on windows, with write cache disabled that shows performance degredation of identity columns. See results posted in DERBY-5471, copied here: Rick, first of all, I want to apologize for not responding to this jira sooner. I allowed other jiras to prioritize over this but I finally got around to running a long set of tests and here are the results of them. I have truned off debugging prints in these test runs. I ran lots of test as explained below on released 10.8.2.2 jars and top of the trunk(revision 1341151) insane jars with write caching off and the test results between the 2 set of jars do vary. I have Windows7 service pack1 laptop(Intel(R) Core(TM) i7-2720QM CPU &lt; at &gt;2.20GHz, 8GB RAM) with IBM jdk 1.6 I chose to run with preallocation sizes of 5 and 20 because I think the default preallocation for 10.8 is 5 and for trunk is 20. Variations of test(with 3 test runs of each on 10.8 and trunk jars) 1)Identity column 10 threads with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 10630 Average throughput (tx/s): 177.16666666666666 15427 successful transactions, including warmup phase. Test run 2) Number of transactions: 10432 Average throughput (tx/s): 173.86376893718437 15282 successful transactions, including warmup phase. Test run 3) Number of transactions: 10377 Average throughput (tx/s): 172.89524983755143 14908 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 3002 Average throughput (tx/s): 50.021661612290465 4542 successful transactions, including warmup phase. Test run 2) Number of transactions: 2924 Average throughput (tx/s): 48.733333333333334 4370 successful transactions, including warmup phase. Test run 3) Number of transactions: 2547 Average throughput (tx/s): 42.45 4023 successful transactions, including warmup phase. 2)Identity column 10 threads with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 10677 Average throughput (tx/s): 177.92627649646712 15222 successful transactions, including warmup phase. Test run 2) Number of transactions: 11188 Average throughput (tx/s): 186.46355894068432 15744 successful transactions, including warmup phase. Test run 3) Number of transactions: 10571 Average throughput (tx/s): 176.18039699338345 15012 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 2453 Average throughput (tx/s): 40.88333333333333 3716 successful transactions, including warmup phase. Test run 2) Number of transactions: 2531 Average throughput (tx/s): 42.18333333333333 3668 successful transactions, including warmup phase. Test run 3) Number of transactions: 3076 Average throughput (tx/s): 51.266666666666666 4615 successful transactions, including warmup phase. 3)Identity column 1 thread with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 5865 Average throughput (tx/s): 97.75 8773 successful transactions, including warmup phase. Test run 2) Number of transactions: 5753 Average throughput (tx/s): 95.88173530441159 8359 successful transactions, including warmup phase. Test run 3) Number of transactions: 6326 Average throughput (tx/s): 105.43333333333334 9231 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 526 Average throughput (tx/s): 8.766666666666667 801 successful transactions, including warmup phase. Test run 2) Number of transactions: 546 Average throughput (tx/s): 9.1 831 successful transactions, including warmup phase. Test run 3) Number of transactions: 572 Average throughput (tx/s): 9.533174447092549 841 successful transactions, including warmup phase. 4)Identity column 1 thread with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 5948 Average throughput (tx/s): 99.13333333333334 8799 successful transactions, including warmup phase. Test run 2) Number of transactions: 5658 Average throughput (tx/s): 94.3 8337 successful transactions, including warmup phase. Test run 3) Number of transactions: 6314 Average throughput (tx/s): 105.21755070072822 9197 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 470 Average throughput (tx/s): 7.833202779953668 737 successful transactions, including warmup phase. Test run 2) Number of transactions: 548 Average throughput (tx/s): 9.133333333333333 814 successful transactions, including warmup phase. Test run 3) Number of transactions: 559 Average throughput (tx/s): 9.315424610051993 851 successful transactions, including warmup phase. 5)Sequence column 10 threads with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 20978 Average throughput (tx/s): 349.6275062082299 31469 successful transactions, including warmup phase. Test run 2) Number of transactions: 20496 Average throughput (tx/s): 341.6 30196 successful transactions, including warmup phase. Test run 3) Number of transactions: 17433 Average throughput (tx/s): 290.545157580707 24772 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 470 Average throughput (tx/s): 7.833202779953668 737 successful transactions, including warmup phase. Test run 2) Number of transactions: 548 Average throughput (tx/s): 9.133333333333333 814 successful transactions, including warmup phase. Test run 3) Number of transactions: 559 Average throughput (tx/s): 9.315424610051993 851 successful transactions, including warmup phase. 6)Sequence column 10 threads with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 19927 Average throughput (tx/s): 332.11113148114197 30250 successful transactions, including warmup phase. Test run 2) Number of transactions: 21048 Average throughput (tx/s): 350.8 31331 successful transactions, including warmup phase. Test run 3) Number of transactions: 20707 Average throughput (tx/s): 345.1166666666667 30251 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 7038 Average throughput (tx/s): 117.29804503258279 13041 successful transactions, including warmup phase. Test run 2) Number of transactions: 10129 Average throughput (tx/s): 168.8138531024483 15210 successful transactions, including warmup phase. Test run 3) Number of transactions: 13775 Average throughput (tx/s): 229.58333333333334 19609 successful transactions, including warmup phase. 7)Sequence column 1 thread with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 12989 Average throughput (tx/s): 216.47972533791105 19048 successful transactions, including warmup phase. Test run 2) Number of transactions: 12521 Average throughput (tx/s): 208.68333333333334 18560 successful transactions, including warmup phase. Test run 3) Number of transactions: 11970 Average throughput (tx/s): 199.5 17763 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 6853 Average throughput (tx/s): 114.21476308728188 10286 successful transactions, including warmup phase. Test run 2) Number of transactions: 7277 Average throughput (tx/s): 121.2813119781337 10733 successful transactions, including warmup phase. Test run 3) Number of transactions: 7293 Average throughput (tx/s): 121.55 10772 successful transactions, including warmup phase. 8)Sequence column 1 thread with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 12059 Average throughput (tx/s): 200.93979637745156 17215 successful transactions, including warmup phase. Test run 2) Number of transactions: 11071 Average throughput (tx/s): 184.51359144014268 16884 successful transactions, including warmup phase. Test run 3) Number of transactions: 12073 Average throughput (tx/s): 201.21331311144814 17489 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 2479 Average throughput (tx/s): 41.31597806703222 3673 successful transactions, including warmup phase. Test run 2) Number of transactions: 2657 Average throughput (tx/s): 44.2825952900785 3921 successful transactions, including warmup phase. Test run 3) Number of transactions: 2518 Average throughput (tx/s): 41.96596723387943 3698 successful transactions, including warmup phase. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Mike Matrigali (JIRA 2012-05-23T21:27:40 [jira] [Commented] (DERBY-5471) Stress test for identity columns and sequence seem to be taking longer on trunk compared to 10.8.2.2 RC3 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95660 <pre> [ https://issues.apache.org/jira/browse/DERBY-5471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&amp;focusedCommentId=13281926#comment-13281926 ] Mike Matrigali commented on DERBY-5471: --------------------------------------- the latest results concern me, I did not expect identity column performance to slow down for trunk as part of my changes - and thought that rick's posted performance tests verified that. I am going to create a new issue to just concentrate on identity performance in trunk (and soon to be 10.9). The goal of the changes were to keep the lazy commit for identity columns but not for sequences. So expected performance of identity columns to stay the same. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Mike Matrigali (JIRA 2012-05-23T21:23:40 [jira] [Commented] (DERBY-5471) Stress test for identity columns and sequence seem to be taking longer on trunk compared to 10.8.2.2 RC3 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95659 <pre> [ https://issues.apache.org/jira/browse/DERBY-5471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&amp;focusedCommentId=13281820#comment-13281820 ] Mamta A. Satoor commented on DERBY-5471: ---------------------------------------- Rick, first of all, I want to apologize for not responding to this jira sooner. I allowed other jiras to prioritize over this but I finally got around to running a long set of tests and here are the results of them. I have truned off debugging prints in these test runs. I ran lots of test as explained below on released 10.8.2.2 jars and top of the trunk(revision 1341151) insane jars with write caching off and the test results between the 2 set of jars do vary. I have Windows7 service pack1 laptop(Intel(R) Core(TM) i7-2720QM CPU &lt; at &gt;2.20GHz, 8GB RAM) with IBM jdk 1.6 I chose to run with preallocation sizes of 5 and 20 because I think the default preallocation for 10.8 is 5 and for trunk is 20. Variations of test(with 3 test runs of each on 10.8 and trunk jars) 1)Identity column 10 threads with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 10630 Average throughput (tx/s): 177.16666666666666 15427 successful transactions, including warmup phase. Test run 2) Number of transactions: 10432 Average throughput (tx/s): 173.86376893718437 15282 successful transactions, including warmup phase. Test run 3) Number of transactions: 10377 Average throughput (tx/s): 172.89524983755143 14908 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 3002 Average throughput (tx/s): 50.021661612290465 4542 successful transactions, including warmup phase. Test run 2) Number of transactions: 2924 Average throughput (tx/s): 48.733333333333334 4370 successful transactions, including warmup phase. Test run 3) Number of transactions: 2547 Average throughput (tx/s): 42.45 4023 successful transactions, including warmup phase. 2)Identity column 10 threads with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 10677 Average throughput (tx/s): 177.92627649646712 15222 successful transactions, including warmup phase. Test run 2) Number of transactions: 11188 Average throughput (tx/s): 186.46355894068432 15744 successful transactions, including warmup phase. Test run 3) Number of transactions: 10571 Average throughput (tx/s): 176.18039699338345 15012 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 2453 Average throughput (tx/s): 40.88333333333333 3716 successful transactions, including warmup phase. Test run 2) Number of transactions: 2531 Average throughput (tx/s): 42.18333333333333 3668 successful transactions, including warmup phase. Test run 3) Number of transactions: 3076 Average throughput (tx/s): 51.266666666666666 4615 successful transactions, including warmup phase. 3)Identity column 1 thread with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 5865 Average throughput (tx/s): 97.75 8773 successful transactions, including warmup phase. Test run 2) Number of transactions: 5753 Average throughput (tx/s): 95.88173530441159 8359 successful transactions, including warmup phase. Test run 3) Number of transactions: 6326 Average throughput (tx/s): 105.43333333333334 9231 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 526 Average throughput (tx/s): 8.766666666666667 801 successful transactions, including warmup phase. Test run 2) Number of transactions: 546 Average throughput (tx/s): 9.1 831 successful transactions, including warmup phase. Test run 3) Number of transactions: 572 Average throughput (tx/s): 9.533174447092549 841 successful transactions, including warmup phase. 4)Identity column 1 thread with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 5948 Average throughput (tx/s): 99.13333333333334 8799 successful transactions, including warmup phase. Test run 2) Number of transactions: 5658 Average throughput (tx/s): 94.3 8337 successful transactions, including warmup phase. Test run 3) Number of transactions: 6314 Average throughput (tx/s): 105.21755070072822 9197 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 470 Average throughput (tx/s): 7.833202779953668 737 successful transactions, including warmup phase. Test run 2) Number of transactions: 548 Average throughput (tx/s): 9.133333333333333 814 successful transactions, including warmup phase. Test run 3) Number of transactions: 559 Average throughput (tx/s): 9.315424610051993 851 successful transactions, including warmup phase. 5)Sequence column 10 threads with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 20978 Average throughput (tx/s): 349.6275062082299 31469 successful transactions, including warmup phase. Test run 2) Number of transactions: 20496 Average throughput (tx/s): 341.6 30196 successful transactions, including warmup phase. Test run 3) Number of transactions: 17433 Average throughput (tx/s): 290.545157580707 24772 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 470 Average throughput (tx/s): 7.833202779953668 737 successful transactions, including warmup phase. Test run 2) Number of transactions: 548 Average throughput (tx/s): 9.133333333333333 814 successful transactions, including warmup phase. Test run 3) Number of transactions: 559 Average throughput (tx/s): 9.315424610051993 851 successful transactions, including warmup phase. 6)Sequence column 10 threads with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 10 10.8 Runs Test run 1) Number of transactions: 19927 Average throughput (tx/s): 332.11113148114197 30250 successful transactions, including warmup phase. Test run 2) Number of transactions: 21048 Average throughput (tx/s): 350.8 31331 successful transactions, including warmup phase. Test run 3) Number of transactions: 20707 Average throughput (tx/s): 345.1166666666667 30251 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 7038 Average throughput (tx/s): 117.29804503258279 13041 successful transactions, including warmup phase. Test run 2) Number of transactions: 10129 Average throughput (tx/s): 168.8138531024483 15210 successful transactions, including warmup phase. Test run 3) Number of transactions: 13775 Average throughput (tx/s): 229.58333333333334 19609 successful transactions, including warmup phase. 7)Sequence column 1 thread with 20 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=20 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 12989 Average throughput (tx/s): 216.47972533791105 19048 successful transactions, including warmup phase. Test run 2) Number of transactions: 12521 Average throughput (tx/s): 208.68333333333334 18560 successful transactions, including warmup phase. Test run 3) Number of transactions: 11970 Average throughput (tx/s): 199.5 17763 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 6853 Average throughput (tx/s): 114.21476308728188 10286 successful transactions, including warmup phase. Test run 2) Number of transactions: 7277 Average throughput (tx/s): 121.2813119781337 10733 successful transactions, including warmup phase. Test run 3) Number of transactions: 7293 Average throughput (tx/s): 121.55 10772 successful transactions, including warmup phase. 8)Sequence column 1 thread with 5 preallocation java -Dderby.system.home=$derbyHome -Dderby.language.sequence.preallocator=5 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=5,tablesPerGenerator=10,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 1 10.8 Runs Test run 1) Number of transactions: 12059 Average throughput (tx/s): 200.93979637745156 17215 successful transactions, including warmup phase. Test run 2) Number of transactions: 11071 Average throughput (tx/s): 184.51359144014268 16884 successful transactions, including warmup phase. Test run 3) Number of transactions: 12073 Average throughput (tx/s): 201.21331311144814 17489 successful transactions, including warmup phase. Trunk Runs Test run 1) Number of transactions: 2479 Average throughput (tx/s): 41.31597806703222 3673 successful transactions, including warmup phase. Test run 2) Number of transactions: 2657 Average throughput (tx/s): 44.2825952900785 3921 successful transactions, including warmup phase. Test run 3) Number of transactions: 2518 Average throughput (tx/s): 41.96596723387943 3698 successful transactions, including warmup phase. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Mamta A. Satoor (JIRA 2012-05-23T19:19:41 [jira] [Commented] (DERBY-69) RFE: HEX function http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95658 <pre> [ https://issues.apache.org/jira/browse/DERBY-69?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&amp;focusedCommentId=13281812#comment-13281812 ] Dag H. Wanvik commented on DERBY-69: ------------------------------------ I think we would rather want to support the standard &lt;Unicode character string literal&gt;, which would allow hex escapes, e.g. U&amp;"b\00E5t" giving "båt" or U&amp;"b|00E5t" UESCAPE '|' where we choose a non-default quote character. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Dag H. Wanvik (JIRA 2012-05-23T19:15:41 [jira] [Commented] (DERBY-5125) Derby 10.7.1.1 : Build fails with javacc 5 (for Debian packaging) http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95657 <pre> [ https://issues.apache.org/jira/browse/DERBY-5125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&amp;focusedCommentId=13281699#comment-13281699 ] Dag H. Wanvik commented on DERBY-5125: -------------------------------------- I have uploaded the JavaCC patch to http://java.net/jira/browse/JAVACC-244. We probably don't want to use a patched version of JavaCC for production use, so I will let this issue remain open. Patching up the generated code is also a bit messy, so I think I'll leave this issue open for now. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Dag H. Wanvik (JIRA 2012-05-23T16:16:41 Re: need a build job for the 10.9 branch http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95656 <pre> Hi Rick, I just created https://builds.apache.org/job/Derby-branch-10.9/ , but the queue is pretty long at the moment so I can't test it. I have scheduled a build, we'll just have to wait and see what happens. </pre> Kristian Waagan 2012-05-23T16:00:01 Regression Test Report - Daily 1341544 - Sun DBTG http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95655 <pre>[Auto-generated mail] *Daily* 1341544/2012-05-22 18:00:08 MEST Failed Tests OK Skip Duration Suite ------------------------------------------------------- *Jvm: 1.7* lin 0 15840 15840 0 .% suitesAll 0 15 15 0 .% jdbcapiAutoLoad 0 14 14 0 .% JDBCDriversAll 0 15 15 0 .% JDBCDriversClient 0 14 14 0 .% JDBCDriversEmbedded 0 166 166 0 .% derbyall 0 2 2 0 .% compatibility 0 2 2 0 .% demoSuite sol 0 15840 15840 0 .% suitesAll 0 15 15 0 .% jdbcapiAutoLoad 0 14 14 0 .% JDBCDriversAll 0 15 15 0 .% JDBCDriversClient 0 14 14 0 .% JDBCDriversEmbedded 0 166 166 0 .% derbyall 0 2 2 0 .% compatibility 0 2 2 0 .% demoSuite sol32 0 15840 15840 0 .% suitesAll NA NA NA NA jdbcapiAutoLoad 0 14 14 0 .% JDBCDriversAll 0 15 15 0 .% JDBCDriversClient 0 14 14 0 .% JDBCDriversEmbedded 0 166 166 0 .% derbyall 0 2 2 0 .% compatibility NA NA NA NA demoSuite vista-64 0 15831 15831 0 .% suitesAll 0 15 15 0 .% jdbcapiAutoLoad 0 14 14 0 .% JDBCDriversAll 0 15 15 0 .% JDBCDriversClient 0 14 14 0 .% JDBCDriversEmbedded 0 166 166 0 .% derbyall NA NA NA NA compatibility 0 2 2 0 .% demoSuite Details in http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/testing/Limited/testSummary-1341544.html Attempted failure analysis in http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/FailReports/1341544_bySig.html *Jvm: 1.6* lin 0 15735 15735 0 1686.14% suitesAll 0 15 15 0 .% jdbcapiAutoLoad 0 14 14 0 .% JDBCDriversAll 0 15 15 0 .% JDBCDriversClient 0 14 14 0 .% JDBCDriversEmbedded 0 166 166 0 37.75% derbyall 0 2 2 0 111.92% compatibility 0 2 2 0 .% demoSuite sles 0 15735 15735 0 1066.51% suitesAll 0 15 15 0 .% jdbcapiAutoLoad 0 14 14 0 .% JDBCDriversAll 0 15 15 0 .% JDBCDriversClient 0 14 14 0 .% JDBCDriversEmbedded 0 166 166 0 35.39% derbyall 0 2 2 0 68.86% compatibility 0 2 2 0 .% demoSuite sol 0 15723 15723 0 1178.91% suitesAll 0 15 15 0 .% jdbcapiAutoLoad 0 14 14 0 .% JDBCDriversAll 0 15 15 0 .% JDBCDriversClient 0 14 14 0 .% JDBCDriversEmbedded 0 166 166 0 29.80% derbyall 0 2 2 0 68.72% compatibility 0 2 2 0 .% demoSuite sol32 0 15723 15723 0 86.40% suitesAll 0 15 15 0 46.15% jdbcapiAutoLoad 0 14 14 0 58.33% JDBCDriversAll 0 15 15 0 46.15% JDBCDriversClient 0 14 14 0 8.33% JDBCDriversEmbedded 0 166 166 0 1098.58% derbyall 0 2 2 0 14850.00% compatibility 0 2 2 0 700.00% demoSuite solN+1 0 15723 15723 0 238.42% suitesAll 0 15 15 0 .% jdbcapiAutoLoad 0 14 14 0 .% JDBCDriversAll 0 15 15 0 .% JDBCDriversClient 0 14 14 0 .% JDBCDriversEmbedded 0 166 166 0 45.08% derbyall 0 2 2 0 76.58% compatibility 0 2 2 0 .% demoSuite sparc 0 15723 15723 0 590.02% suitesAll 0 15 15 0 .% jdbcapiAutoLoad 0 14 14 0 .% JDBCDriversAll 0 15 15 0 .% JDBCDriversClient 0 14 14 0 .% JDBCDriversEmbedded 0 166 166 0 23.08% derbyall 0 2 2 0 72.76% compatibility 0 2 2 0 .% demoSuite vista 0 15724 15724 0 202.21% suitesAll 0 15 15 0 .% jdbcapiAutoLoad 0 14 14 0 .% JDBCDriversAll 0 15 15 0 .% JDBCDriversClient 0 14 14 0 .% JDBCDriversEmbedded 0 166 166 0 45.21% derbyall NA NA NA NA compatibility 0 2 2 0 .% demoSuite vista-64 0 15724 15724 0 290.97% suitesAll 0 15 15 0 .% jdbcapiAutoLoad 0 14 14 0 .% JDBCDriversAll 0 15 15 0 .% JDBCDriversClient 0 14 14 0 .% JDBCDriversEmbedded 0 166 166 0 44.53% derbyall NA NA NA NA compatibility 0 2 2 0 .% demoSuite Details in http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.6/testing/Limited/testSummary-1341544.html Attempted failure analysis in http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.6/FailReports/1341544_bySig.html *Jvm: 1.5* lin 0 167 167 0 37.33% derbyall 0 13755 13755 0 2855.89% suitesAll sles 0 167 167 0 33.88% derbyall 0 13755 13755 0 1698.67% suitesAll sol 0 167 167 0 32.80% derbyall 0 13743 13743 0 2240.56% suitesAll sol32 0 167 167 0 1169.01% derbyall 0 13743 13743 0 103.61% suitesAll solN+1 0 167 167 0 41.62% derbyall 0 13743 13743 0 2411.99% suitesAll sparc 0 167 167 0 23.36% derbyall 0 13743 13743 0 1405.04% suitesAll vista 0 167 167 0 34.29% derbyall 0 13744 13744 0 1443.54% suitesAll vista-64 0 167 167 0 44.78% derbyall 0 13744 13744 0 331.36% suitesAll Details in http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.5/testing/Limited/testSummary-1341544.html Attempted failure analysis in http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.5/FailReports/1341544_bySig.html *Jvm: phoneME* ubuntu 0 7034 7034 0 .% suitesAll Details in http://dbtg.foundry.sun.com/derby/test/Daily/javaME/testing/Limited/testSummary-1341544.html Attempted failure analysis in http://dbtg.foundry.sun.com/derby/test/Daily/javaME/FailReports/1341544_bySig.html ------------------------------------------------------- Changes in http://dbtg.foundry.sun.com/derby/test/Daily/UpdateInfo/1341544.txt ( All results in http://dbtg.foundry.sun.com/derby/test/ ) </pre> Ole.Solberg-veTT2BtV2gBXrIkS9f7CXA< at >public.gmane.org 2012-05-23T15:55:24 [jira] [Updated] (DERBY-5688) Track tasks needed to produce the 10.9.1 release http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95654 <pre> [ https://issues.apache.org/jira/browse/DERBY-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-5688: --------------------------------- Attachment: derby-5688-02-aa-bumpReleaseIDonTrunk.diff Attaching derby-5688-02-aa-bumpReleaseIDonTrunk.diff, bumping the release id on trunk to 10.10.0.0. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Rick Hillegas (JIRA 2012-05-23T15:52:41 Search Engine Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.apache.db.derby.devel