From: | "Nick Fankhauser" <nickf(at)ontko(dot)com> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org>, "Fernando Nasser" <fnasser(at)redhat(dot)com> |
Subject: | Back to performance issues for a moment... (RE: Prepared Statements) |
Date: | 2003-07-18 15:15:54 |
Message-ID: | NEBBLAAHGLEEPCGOBHDGMEHJHMAA.nickf@ontko.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
> In any case, try using server prepared statements by setting your
statement to
> use that option (you must be using a backend at least of version 7.3):
>
> setUseServerPrepare(true);
Hi folks-
Sorry to pull things backward here, but having set my web user up with sane
grants, I'm a bit more concerned about the performance issues- I can't find
this method in the Sun JDBC spec, so I'm assuming it is PostgreSQL-specific?
Is this the correct way to use it:
PreparedStatement ps = db.prepareStatement("select foo from bar where foo
like ?");
ps.setUseServerPrepare(true);
.
.
.
ps.setString(1, "fubar");
ResultSet rs = ps.executeQuery();
(Where the first two lines get executed once when I init my app, but the
last two lines may get executed any number of times.)
Also- is the javadoc for postgresql JDBC online anywhere for folks like
myself who just download the current stable jarfile?
Thanks
-NF
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Tkach | 2003-07-18 15:18:10 | Re: Prepared Statements |
Previous Message | wsheldah | 2003-07-18 15:10:22 | Re: Prepared Statements |