Re: [GENERAL] Does preparing statements other than selects help performance?

2005-08-06 Thread Jeff Davis
David Goodenough wrote: On Friday 05 August 2005 11:57, Martijn van Oosterhout wrote: On Fri, Aug 05, 2005 at 10:08:42AM +0100, David Goodenough wrote: I was looking at an application recently which was written in Java and used Postgresql as it DB. In it extensive use had been made of

[GENERAL] Does preparing statements other than selects help performance?

2005-08-05 Thread David Goodenough
I was looking at an application recently which was written in Java and used Postgresql as it DB. In it extensive use had been made of PreparedStatements both for SELECTs and for INSERT, UPDATE and DELETE statements. Some of the routines had multiple UPDATEs doing much the same thing but with

Re: [GENERAL] Does preparing statements other than selects help performance?

2005-08-05 Thread Martijn van Oosterhout
On Fri, Aug 05, 2005 at 10:08:42AM +0100, David Goodenough wrote: I was looking at an application recently which was written in Java and used Postgresql as it DB. In it extensive use had been made of PreparedStatements both for SELECTs and for INSERT, UPDATE and DELETE statements. Some of

Re: [GENERAL] Does preparing statements other than selects help performance?

2005-08-05 Thread Richard Huxton
David Goodenough wrote: This set me thinking (always dangerous). I can see how a SELECT can be helped by preparing the statement, but not really how an INSERT could or, other than the SELECT implicit in the WHERE clause on an UPDATE or DELETE, how UPDATE or DELETE statements would be helped.

Re: [GENERAL] Does preparing statements other than selects help performance?

2005-08-05 Thread David Goodenough
On Friday 05 August 2005 11:57, Martijn van Oosterhout wrote: On Fri, Aug 05, 2005 at 10:08:42AM +0100, David Goodenough wrote: I was looking at an application recently which was written in Java and used Postgresql as it DB. In it extensive use had been made of PreparedStatements both for