Обсуждение: Slow performance updating CLOB data

Поиск
Список
Период
Сортировка

Slow performance updating CLOB data

От
Nicola Zanaga
Дата:
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 ?