Home >
Back-end > In DB2, IO performance problems about clob fields
In DB2, IO performance problems about clob fields
I found in the project, the same table, one of the field is varchar2 (8192) type, tps1000 pressure measurement, diskbusy is good also, often keep below 10, but when I put the field types into a clob fields, diskbusy will be very high, often by more than 80%, but also by every time writing table time average 0 to 10 milliseconds, into 10-100 milliseconds, is this why?