Re: Slow performance updating CLOB data - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject Re: Slow performance updating CLOB data
Date
Msg-id nmgchh$8vi$1@ger.gmane.org
Whole thread Raw
In response to Slow performance updating CLOB data  (Nicola Zanaga <NZanaga@efsw.it>)
List pgsql-jdbc
Nicola Zanaga schrieb am 17.07.2016 um 11:39:
> Hi, using ResultSet.updateCharacterStream to update a CLOB is very slow.
>
> Most of the time is spent in method PgResultSet.isUpdateable  because the table has a primary key but doesn't have a
"oid"column. 
>
> So the code tries to get primary keys from the query, using getMetaData().getPrimaryKeys.
> This is a very slow process.
>
> There is any workaround ?

Are you using setCharacterStream()? Why aren't you using setString()?

Please show us the Java code.



pgsql-jdbc by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Slow performance updating CLOB data
Next
From: Nicola Zanaga
Date:
Subject: R: Slow performance updating CLOB data