Re: refreshRow is slow - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: refreshRow is slow
Date
Msg-id 4B511515.6090809@opencloud.com
Whole thread Raw
In response to Re: refreshRow is slow  ("John T. Dow" <john@johntdow.com>)
Responses Re: refreshRow is slow  ("John T. Dow" <john@johntdow.com>)
Re: refreshRow is slow  ("John T. Dow" <john@johntdow.com>)
Re: refreshRow is slow  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
John T. Dow wrote:

> Certainly that piece of code can be made more efficient. One query ought to be able to return all the primary keys.

It's not the PKs it is after (it's already worked those out earlier),
it's the column names to select to populate the rest of the resultset.

But yes, it could be more efficient. We'd need a static String[]
Field.getColumnNames(Connection,Field[]) method or similar.

-O

pgsql-jdbc by date:

Previous
From: Craig Ringer
Date:
Subject: Re: COPY using Hibernate
Next
From: "John T. Dow"
Date:
Subject: Re: refreshRow is slow