Prepare Statement

From: "Jie Liang" <jie(at)stbernard(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-sql(at)postgresql(dot)org>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Prepare Statement
Date: 2004-06-14 23:32:57
Message-ID: E7E213858379814A9AE48CA6754F5ECB02A70FCA@mail01.stbernard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-sql

Hi,

I have a question about performance, in SQL commands: there is a
prepare/execute command, document says it will improve the performance
while repeatly execute a statement. In java.sql: there is a
PreparedStatement object, which can store precompiled SQL statement,
document says it can improve the performance also.
If I use java jdbc to connect postgresql database, which one I should
use? Can I use both?

Thanks.

Jie Liang

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message tmp 2004-06-15 15:36:26 cursor "jdbc_curs_1" does not exist
Previous Message André Gomes 2004-06-14 18:32:43 Question about encoding

Browse pgsql-sql by date

  From Date Subject
Next Message Andrei Bintintan 2004-06-15 07:05:40 Re: Last insert id
Previous Message Richard Poole 2004-06-14 20:44:15 Re: Scalar subqueries