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