[
https://issues.apache.org/jira/browse/DERBY-6841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15006041#comment-15006041
]
Xavion commented on DERBY-6841:
-------------------------------
Thank-you both for your efforts so far. I'm sorry that you had to go to that
trouble, Rick. I hope it didn't take too long to write that program.
I'll start by reiterating that I used "System.nanoTime()" in all of my tests as
well. The other thing I'd like to note is that the database engine can be
restarted after shutdown via "DriverManager.registerDriver(new
org.apache.derby.jdbc.EmbeddedDriver());". Utilising this would enable you to
run the shutdown test multiple times per invocation of the program.
The fact that v10.12.1.1 appears to be shutting down the database engine much
faster could just be a mirage. In an earlier comment, I explained why I
thought that v10.12.1.1 was leaving the databases in a suboptimal state upon
shutdown. To go directly to said comment, just search for "I think part of
this problem could be due to" on this page.
The way I see it, the results Bryan is receiving could be due to one of two
factors. Firstly, it could be a sign that the "slowness" bug of v10.12.1.1 has
(generally) been fixed in trunk. In order to know this for sure, we'd need one
or both of you to run this test against both v10.12.1.1 and trunk sequentially.
Bryan's results could instead be due to having run these tests in a virtual
machine. In order to ensure you're getting the full speed of your CPU, I'd
advise rerunning the tests in your native OS. Rick's code appears to be
cross-platform, and I encountered this problem on all of mine (Windows, OS X,
and Linux).
> 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)
