Re: Query preparation - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Query preparation
Date
Msg-id 49E4AEAC.5000700@opencloud.com
Whole thread Raw
In response to Query preparation  (John Lister <john.lister-ps@kickstone.com>)
Responses Re: Query preparation  (John Lister <john.lister-ps@kickstone.com>)
Re: Query preparation  (John Lister <john.lister-ps@kickstone.com>)
List pgsql-jdbc
John Lister wrote:
> Hi, i was wondering if there is any reason why the query preparation is
> done when the query is executed instead of when the preparedStatement is
> created.

It would be an extra network round-trip on every query, and there's no
requirement to prepare it early.

> Has any one looked into moving it?

Why would you want to move it?

-O

pgsql-jdbc by date:

Previous
From: John Lister
Date:
Subject: Query preparation
Next
From: John Lister
Date:
Subject: Re: Query preparation