"Georgi Cholakov" <g.cholakov@isy-dc.com> wrote in message news:be9f1956.0410072320.7de070c6@posting.google.c om...
> Hi, fellows
>
> I have Informix 7.30.UC10, running on HP Unix. When I put data, larger
> than 1MB into BYTE column using JDBC driver version 2.21.JC3 (JDK
> 1.4.2), it takes very long time to finish the operation. For example,
> if the data is 1MB it takes 23 secs. When I try to put 18MB, the
> duration of that operation is 440 secs and checkpoint duration in the
> online.log is 10 secs - is it too long?
>
> Did someone face this problem?
> Any solutions?

You need to change default settings at the client side. Increase FET_BUF_SIZE.

Also looks like the BYTE column is in table. You need to move that column into
a blob space. That will help in bypassing buffers.