[ https://issues.apache.org/jira/browse/DERBY-6841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15006016#comment-15006016 ]
Bryan Pendleton commented on DERBY-6841: ---------------------------------------- Hi Rick, thanks for exploring this. Without doing any deep study, I simply ran your program 6 times: 3x with trunk, and 3x with the 10.11 "lib" distribution. This was on my Fedora 22 VM, which I know is not the best test environment, but maybe these data points are useful. Here's the timings. First, 3x with trunk: [bpendleton@Fedora22 DERBY-6841]$ ls DERBY_6841.class DERBY_6841$DurationCounter.class DERBY_6841.java [bpendleton@Fedora22 DERBY-6841]$ java -cp .:$CLASSPATH DERBY_6841 Booted database 0 average over 100 times = 53.67 Shutdown database 0 average over 100 times = 24.83 Shutdown engine average over 1 times = 4.0 [bpendleton@Fedora22 DERBY-6841]$ java -cp .:$CLASSPATH DERBY_6841 Booted database 0 average over 100 times = 37.63 Shutdown database 0 average over 100 times = 23.32 Shutdown engine average over 1 times = 4.0 [bpendleton@Fedora22 DERBY-6841]$ java -cp .:$CLASSPATH DERBY_6841 Booted database 0 average over 100 times = 49.01 Shutdown database 0 average over 100 times = 40.51 Shutdown engine average over 1 times = 5.0 Next, 3x with 10.11: [bpendleton@Fedora22 DERBY-6841]$ java -cp .:db-derby-10.11.1.1-lib/lib/derbyrun.jar DERBY_6841 Booted database 0 average over 100 times = 45.19 Shutdown database 0 average over 100 times = 21.63 Shutdown engine average over 1 times = 3.0 [bpendleton@Fedora22 DERBY-6841]$ java -cp .:db-derby-10.11.1.1-lib/lib/derbyrun.jar DERBY_6841 Booted database 0 average over 100 times = 36.33 Shutdown database 0 average over 100 times = 20.84 Shutdown engine average over 1 times = 5.0 [bpendleton@Fedora22 DERBY-6841]$ java -cp .:db-derby-10.11.1.1-lib/lib/derbyrun.jar DERBY_6841 Booted database 0 average over 100 times = 32.57 Shutdown database 0 average over 100 times = 21.51 Shutdown engine average over 1 times = 4.0 To my eye, the variance in run times is pretty high, and I'm not eager to claim I can see any patterns in these numbers. But I certainly don't see a 5x difference in times between the two configurations, in my environment. > Derby v10.12.1.1 is horribly slow compared to v10.11.1.1 in embedded mode > ------------------------------------------------------------------------- > > Key: DERBY-6841 > URL: https://issues.apache.org/jira/browse/DERBY-6841 > Project: Derby > Issue Type: Bug > Components: JDBC, SQL > Affects Versions: 10.12.1.1 > Environment: OS: Windows, OS X, Linux > CPU: Quad-Core Intel i5 > App: Swing, multi-threaded > Reporter: Xavion > Fix For: 10.11.1.1 > > Attachments: DERBY_6841.java > > > It takes much longer to open, read, and close embedded databases using > v10.12.1.1 than it did with v10.11.1.1. What ever changes you guys made over > the last year and a bit have definitely been for the worse. > Below are the results of the repetition tests I've just run on the same > computer with the same databases. Let me know if you need to know about the > sizes of the databases and/or the file type they contain. > Connecting with v10.11.1.1: > Database opened in 0.82 seconds. > Database opened in 0.77 seconds. > Database opened in 0.88 seconds. > Database opened in 0.77 seconds. > Database opened in 0.77 seconds. > Database opened in 0.96 seconds. > Database opened in 0.74 seconds. > Connecting with v10.12.1.1: > Database opened in 1.98 seconds. > Database opened in 2.07 seconds. > Database opened in 1.97 seconds. > Database opened in 2.01 seconds. > Database opened in 2.01 seconds. > Database opened in 2.00 seconds. > Database opened in 2.03 seconds. > Reading with v10.11.1.1: > Database processed in 6.17 seconds. > Database processed in 4.00 seconds. > Database processed in 3.67 seconds. > Database processed in 3.66 seconds. > Database processed in 3.78 seconds. > Database processed in 3.69 seconds. > Database processed in 3.74 seconds. > Reading with v10.12.1.1: > Database processed in 7.29 seconds. > Database processed in 4.54 seconds. > Database processed in 4.88 seconds. > Database processed in 4.65 seconds. > Database processed in 4.34 seconds. > Database processed in 4.35 seconds. > Database processed in 4.50 seconds. > Disconnecting with v10.11.1.1: > Database closed in 0.11 seconds. > Database closed in 0.13 seconds. > Database closed in 0.15 seconds. > Database closed in 0.14 seconds. > Database closed in 0.10 seconds. > Database closed in 0.13 seconds. > Database closed in 0.14 seconds. > Disconnecting with v10.12.1.1: > Database closed in 0.74 seconds. > Database closed in 0.87 seconds. > Database closed in 0.76 seconds. > Database closed in 0.87 seconds. > Database closed in 0.85 seconds. > Database closed in 0.69 seconds. > Database closed in 0.84 seconds. -- This message was sent by Atlassian JIRA (v6.3.4#6332)