Re: [SQL] Prepare Statement

2004-06-15 Thread Jie Liang
, 2004 4:33 PM To: Tom Lane Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] 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

[SQL] Prepare Statement

2004-06-14 Thread Jie Liang
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