Re: Array passing - Mailing list pgsql-jdbc

From John Lister
Subject Re: Array passing
Date
Msg-id 49DDAF29.7040102@kickstone.com
Whole thread Raw
In response to Re: Array passing  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Oliver Jowett wrote:
> John Lister wrote:
>
>> Personally I think the extra network traffic is worth it.
>
> Maybe for your use case, but are you prepared to make that decision
> for every user of the driver?
>
> (also, it's the added latency that's really the problem, for simple
> queries you could end up doubling the execution time)
>

I agree and wasn't suggesting it be applied to everyone/query. I was
planning to add an option (as is already the case in the original patch).
Additionally it probably only makes sense to do this for
PreparedStatements as normal Statements are likely to be simple one off
queries. Also given the jdbc docs states they are pre-compiled you'd
expect prepared statements to suffer some slight overhead during the
preparation in return for better execution time.

Thoughts

pgsql-jdbc by date:

Previous
From: "Peter"
Date:
Subject: Re: String Formula to calculate the value
Next
From: Raghavendra b
Date:
Subject: Reminder: Please Respond to Raghavendra's Invitation