Hello Derby community,
It is stated in the latest 10.7 tuning documentation that a connection
only needs to compile a PreparedStatement once, however the runtime
statistics's Compile Time remains static. The following is a JRuby
script that shows PreparedStatement usage:
The runtime statistics yields the following output for statement 1
(first prepared statement compile) and statement 2 (same prepared
statement executed again with different parameter):
Begin Compilation Timestamp : 2011-02-24 13:09:50.816
End Compilation Timestamp : 2011-02-24 13:09:50.901
[mailto:bpendleton.de...@gmail.com]
Sent: Thu 2/24/2011 8:17 PM
To: Derby Discussion
Subject: Re: Explanation of Compile Time metric in Runtime Statistics
The runtime statistics yields the following output for statement 1
(first prepared statement compile) and statement 2 (same prepared
statement