Skip site navigation (1) Skip section navigation (2)

Re: Prepare Statement

From: "Jie Liang" <jie(at)stbernard(dot)com>
To: "Kris Jurka" <books(at)ejurka(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Prepare Statement
Date: 2004-06-18 16:43:38
Message-ID: E7E213858379814A9AE48CA6754F5ECB03451962@mail01.stbernard.com (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-sql
Nope, I think you are right. The improvement of performance will be
minimal. Because that to parse "SELECT * FROM myfunction(?,?,?)" is very
very quick.
However, I am still thinking if I call one SELECT and one DELECT and one
UPDATE and one INSERT a thousand times against same table with different
arguments, should I consider performance iusse?

Secondly, I assume the function should be a pre-compiled object stored
on server side, doesn't it.

Thanks.


Jie Liang 

-----Original Message-----
From: Kris Jurka [mailto:books(at)ejurka(dot)com] 
Sent: Thursday, June 17, 2004 10:51 PM
To: Jie Liang
Cc: pgsql-sql(at)postgresql(dot)org; pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Prepare Statement




On Thu, 17 Jun 2004, Jie Liang wrote:

> Hmm, intersting.
> I am using jdk 1.3.1, and pg74.213.jdbc2.jar driver, I hope this bug 
> could be fixed in later version.
> 

I suppose, but I'm going to put it pretty close to the bottom of my todo

list because it still works even though it doesn't use a server prepared

statement, and as I mentioned earlier the performance improvement if any

will be minimal.  Have you done any testing to show that you are even 
getting a performance gain?

Kris Jurka

Responses

pgsql-sql by date

Next:From: Jie LiangDate: 2004-06-18 16:52:18
Subject: Re: Prepare Statement
Previous:From: Kris JurkaDate: 2004-06-18 05:51:19
Subject: Re: Prepare Statement

pgsql-jdbc by date

Next:From: Jie LiangDate: 2004-06-18 16:52:18
Subject: Re: Prepare Statement
Previous:From: Tom LaneDate: 2004-06-18 16:32:52
Subject: Re: Nested transactions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group