On 09/27/2002 10:43:47 PM Barry Lind wrote:
> I think the real question here is when does it make sense to use server
> side prepared statements. In the little bit of testing I have done, I
> would say the answer is rarely. You need many factors to come into
> place for it to make sense to use server side prepared statements:
>
> 1) The statement needs to be big and complex such that there is
> significant overhead in the parsing and planning stages of execution.
Hmm, don't know how this relates to PostgreSQL, but I've got an example to the contrary with Oracle (8.1.6).
A collegue of mine is developing an application-specific dataloader which does a lot of simple select/update/insert
statements.When he changed the (java/JDBC) code from using Statement to PreparedStatement, he got an instant 60%
increasein performance.
Maarten
------------------------------------------------------------- ---
Visit our Internet site at http://www.reuters.com
Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Reuters Ltd.