Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> preparing the same statement over and over
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
![]() |
![]() |