Our database has quite a few CLOB and BLOB columns in multiple tables. I have noticed that the performance of the database calls is extremely poor against Oracle versus MySQL (we are using CoreLab .NET drivers for both). I am hoping that maybe someone would know if the issue is with the driver or with the Oracle database's inability to handle CLOBs and BLOBs as effectively as MySQL. I did notice a significant increase in performance when I converted the columns to VARCHAR2, unfortunately these columns require more than 4 KB of text so I cannot just leave them as VARCHAR2. Has anyone experienced this? Does the CoreLab team know if internally when fetching a CLOB in Oracle the amount of work done is much more than when fetching mediumtext or longtext fields in MySQL.
Thanks,
Irfan