Slow writing data into BLOB through JDBC
Georgi Cholakov found JDBC 2.21.JC3 inserts into a BYTE column very slow on Informix 7.30.UC10 on HP-UX (1 MB in 23 seconds, 18 MB in 440). rkusenet advised raising FET_BUF_SIZE and moving the column to a blobspace; John Carlson noted BLOBs in a regular dbspace go through buffers. Georgi confirmed it was in a dbspace and would test with a blobspace.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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? Thank you for your help. Georgi Cholakov ISY Intellect g.cholakov@isy-dc.com
"Georgi Cholakov" <g.cholakov@isy-dc.com> wrote in message news:be9f1956.0410072320.7de070c6@posting.google.com... > 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.
On 8 Oct 2004 00:20:55 -0700, g.cholakov@isy-dc.com (Georgi Cholakov) wrote: >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? Is the BLOB column stored in a regular dbspace or in a blobspace? Any BLOB data stored in a regular dbspace will go through the buffers . . . JWC
> Is the BLOB column stored in a regular dbspace or in a blobspace? Any > BLOB data stored in a regular dbspace will go through the buffers . . > . > JWC The BLOB is in dbspace. I will create a blobspace and make a test again. Thank you for your help. Georgi Cholakov