About Connections and PreparedStatements

Поиск
Список
Период
Сортировка
От Hector Rosas
Тема About Connections and PreparedStatements
Дата
Msg-id 25266c5c0510121210k8e16cf8id841ba11120aaf8b@mail.gmail.com
обсуждение исходный текст
Ответы Re: About Connections and PreparedStatements  (Oliver Jowett <oliver@opencloud.com>)
Re: About Connections and PreparedStatements  (Mark Lewis <mark.lewis@mir3.com>)
Список pgsql-jdbc
Hello, I have a doubt with connections and PreparedStatemens. If I open a connection to Postgres and then request a prepared statement, this will be compiled and reused as long as I don't close the connection right? Or it doesn't matter if I close the connection, I'm using PooledConnection provided by my container (Orion), I want to know if there's an advantage to keep a connections open, in order to reutilize PreparedStatement. Also, I'm closing PreparedStatement after every query, PreparedStatement need to be closed after every query right? I mean, is not closing a PreparedStatement a way to increase performance?

Well, thanks everyone.

Jeziel.

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Russell Francis
Дата:
Сообщение: Re: queries against CIDR fail against 8.0.3?
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: About Connections and PreparedStatements