db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6841) Derby v10.12.1.1 is horribly slow compared to v10.11.1.1 in embedded mode
Date Sun, 15 Nov 2015 20:14:11 GMT

    [ 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)

Mime
View raw message