Devart Forums

Hi! We encounter the same problem with a huge performance impact to select rows in a huge table with a CLOB column. Changing the column type to a varchar type is not possible due to length limitations.

Using an OracleConnection to retrieve the data for this specific table would break the architecture of our data access layer. We would be a lot of work and make the code confusing, so we would like to avoid it.

Regarding the performance impact, with a data set of 100 000 rows with clobs that have less than 4000 characters, it takes us 6 min to retrieve the rows in the application while it takes ~10s with the same table with a varchar typed column instead of the clob. The overhead is +3500%.

By chance, do you have any fix or other alternatives so far ?

Thanks in advance