| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> CLOB extremely slow or is it my fault?
Hi
I'm reading 600 Clobs in a simple loop from one table. This takes 2 minutes to complete. I'm using the Java 1.22 JDBC thin driver for Oracle 8i 8.1.5. What am I doing wrong. Here is the code:
ResultSet rs = ...
while (rs.next()){
Clob clob = rs.getClob(3);
String s = clob.getSubString(1, MAX_TEXTITEM_LENGTH);
...
}
where MAX_TEXTITEM_LENGTH is 10000
Any ideas?
--
Alexander Jerusalem
alexander.jerusalem_at_Xchello.at
To mail me remove the X before chello
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sat Feb 12 2000 - 10:55:39 CST
 |
 |