Hello, I have a question on how derby works with prepared statements. The scenario : -1 connection (embedded driver) -1 prepared statement run several times over the database ( does not matter if select, insert ... ) -I keep the connection open but close the prepared statement ( and make sure it is garbage collected ) -On a later stage I create a new prepared statement with the same SQL as the one mentioned before
Question : Does derby re-use the pre-compiled SQL or is it creating another one ? TIA Marco
