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

Re: [SQL] Prepare Statement

From: "Jie Liang" <jie(at)stbernard(dot)com>
To: "Jie Liang" <jie(at)stbernard(dot)com>, "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: Re: [SQL] Prepare Statement
Date: 2004-06-15 16:44:03
Message-ID: E7E213858379814A9AE48CA6754F5ECB0345182D@mail01.stbernard.com (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-sql
Tom,

Does java.sql.PreparedStatement do the same thing as SQL command
prepare/execute ??
Which one should be used while I am using jdbc talking to postgresql? If
using both, do them help the performance?


Thanks.



Jie Liang

-----Original Message-----
From: Jie Liang 
Sent: Monday, June 14, 2004 4:33 PM
To: Tom Lane
Cc: pgsql-sql(at)postgresql(dot)org; pgsql-jdbc(at)postgresql(dot)org
Subject: [SQL] Prepare Statement


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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

pgsql-sql by date

Next:From: Kris JurkaDate: 2004-06-15 18:00:00
Subject: Re: Prepare Statement
Previous:From: Pankaj ChughDate: 2004-06-15 12:28:34
Subject: Number of rows effected

pgsql-jdbc by date

Next:From: tmpDate: 2004-06-15 16:53:58
Subject: Re: cursor "jdbc_curs_1" does not exist
Previous:From: Kris JurkaDate: 2004-06-15 16:06:26
Subject: Re: cursor "jdbc_curs_1" does not exist

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