I think it depends on what type of statement "Executing Statement" is. If it is an insert/update/delete then no. If it is a select statement and it is calling the same statement with the same parameters you will see a difference in the logs.
Since you stated that you are doing a batch I would assume that it is the former of the two above. Why would caching have any influence on the inserts into a DB? Nathan On 8/16/07, Graeme J Sweeney <[EMAIL PROTECTED]> wrote: > > Hi, > > I'm trying to use statementCachingEnabled to see if I can speed up an > insert task and the inserts are executed within a batch. > > The log gives the following sequence: > > Connection > Preparing Statement > Executing Statement > Connection > Preparing Statement > Executing Statement > > Should I get: > > Connection > Preparing Statement > Executing Statement > Executing Statement > > ? > > TIA. > > -- > Graeme - >
