clob is slow?
822892Mar 3 2011 — edited Mar 4 2011fetching of 17k records having clob field takes forever. if I replace the actual field value with null in my query it opens almost immediately. from profiling I can see that it takes ~46% of the entire time doing OCILobRead and ~39% in OCILobGetLength, OCIStmtFetch2 is only about 10%. are those clob fields inherently slow and I should discard their usage or something is wrong with my setup?