Performance of CLOBs in Oracle with and without OraDirect.NET driver

Performance of CLOBs in Oracle with and without OraDirect.NET driver

Postby irfan » Thu 14 Dec 2006 07:31

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
irfan
 
Posts: 15
Joined: Wed 13 Apr 2005 00:56

Postby Alexey » Thu 14 Dec 2006 08:50

Yes, there is a difference in working with LOB objects in Oracle and in MySQL. But Core Lab data providers has nothing to do with this.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle