Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> preparing the same statement over and over

preparing the same statement over and over

From: Markus <MHasenoehrl_at_gmx.net>
Date: 15 Nov 2004 05:24:09 -0800
Message-ID: <d3091c17.0411150524.734bc458@posting.google.com>


Hi!

I am just looking at some code of a Java persistance framework that has a string-constant containing SQL-query and everytime the database is read, this statement is prepared again ... hmm ... never seen such a thing before, therefore my question:

How much is the penalty for re-preparing an already prepared statement? I assume Oracle will not re-prepare it from scratch but use it's cache, so is the penalty just a network-roundtrip or is it (as I fear) higher?

Mant thanks!
Markus Received on Mon Nov 15 2004 - 07:24:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US