Re: Slow performance updating CLOB data
От
Thomas Kellerer
Тема
Re: Slow performance updating CLOB data
Дата
Msg-id
nmgchh$8vi$1@ger.gmane.org
Ответ на
Slow performance updating CLOB data (Nicola Zanaga)
Список
Дерево обсуждения
Slow performance updating CLOB data Nicola Zanaga <NZanaga@efsw.it>
R: Slow performance updating CLOB data Nicola Zanaga <NZanaga@efsw.it>
Re: Slow performance updating CLOB data Thomas Kellerer <spam_eater@gmx.net>
Re: Slow performance updating CLOB data Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
R: Slow performance updating CLOB data Nicola Zanaga <NZanaga@efsw.it>
Re: Slow performance updating CLOB data Dave Cramer <pg@fastcrypt.com>
Re: Slow performance updating CLOB data Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
R: Slow performance updating CLOB data Nicola Zanaga <NZanaga@efsw.it>
Re: Slow performance updating CLOB data Thomas Kellerer <spam_eater@gmx.net>
R: Slow performance updating CLOB data Nicola Zanaga <NZanaga@efsw.it>
Re: Slow performance updating CLOB data Dave Cramer <pg@fastcrypt.com>
Re: Slow performance updating CLOB data Christopher BROWN <brown@reflexe.fr>
Re: Slow performance updating CLOB data Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Slow performance updating CLOB data Thomas Kellerer <spam_eater@gmx.net>
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 по дате отправления
