Re: Slow performance updating CLOB data

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Slow performance updating CLOB data
Date: 2016-07-18 13:01:00
Message-ID: nmijuc$vln$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Nicola Zanaga schrieb am 18.07.2016 um 14:28:
>
> I can change strategy for postgres, but I don’t think is good to issue a query
> like “UPDATE table SET clob = ‘value’ WHERE key = x” if value is more than 10Mb.
>
You should use a PreparedStatement not string literals.
But apart from that, that won't be any different to the SQL that the driver uses.

Why do you think that would be a problem?
The client needs to send 10MB of data, regardless on _how_ it sends that.

Thomas

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Gavin Flower 2016-07-18 19:42:32 Re: Slow performance updating CLOB data
Previous Message Christopher BROWN 2016-07-18 12:55:24 Re: Slow performance updating CLOB data