Slow writing data into BLOB through JDBC

Posted in 2004

Topics: Connectivity: ODBC / JDBC / .NET, Logging & Checkpoints, Java & JDBC Development

Georgi Cholakov — 8 Oct 2004 00:20:55 -0700 — source: Usenet: comp.databases.informix

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

↪ replying to Georgi Cholakov

rkusenet — Fri, 8 Oct 2004 06:00:41 -0400 — source: Usenet: comp.databases.informix

"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.

↪ replying to Georgi Cholakov

John Carlson — Sun, 10 Oct 2004 00:02:43 -0400 — source: Usenet: comp.databases.informix

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

↪ replying to John Carlson

Georgi Cholakov — 10 Oct 2004 22:58:23 -0700 — source: Usenet: comp.databases.informix

> 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

Related threads

Glossary

checkpoint