Posts
415
Comments
233
Trackbacks
42
Fun with Oracle CLOBs

We have been having prolonged adventures with this wonderful data type on my current project.  We are storing XML data in a CLOB field.  In the beginning we used the Oracle ODP.NET provider.  When we got into performance testing we found that saving this data killed our performance.  A couple of the developers did some testing and found that the Microsoft Oracle provider worked at least an order of magnitude better.  I was a little skeptical about moving to the Microsoft provider because I remembered that certain database condition weren't reported very well, but time lines always win.

A short time later the client got a response from Oracle saying we should use a VarChar parameter to send data to a CLOB in the database.  We did some testing and it did perform well, but we figured we had changed enough data access code at this point that we would wait until a maintenance release to consider performing the change.

The system went into pilot and suddenly we started getting failures to insert into the table.  Again the developers did some research and found that any data over 32K would cause this condition.

The solution?  Go back to Oracle's suggestion.

The moral?  Take your medicine now.  It taste worse if you wait.

posted on Thursday, April 13, 2006 5:26 PM Print
Comments
Gravatar
# re: Fun with Oracle CLOBs
Gerhard Stephan
4/26/2006 6:37 AM
In our current project we had the same performance issue using the Oracle Data Provider for .NET and BLOBS. After digging into the problem I found a solution that is quite fast and does not have the limitation of 32k.

Perhaps it can help you to solve your problem too.

Cheers
Gerhard

http://jachman.wordpress.com/2006/04/26/slow-oracle-blob-upload-with-c-net-or-how-to-fasten-it/

Post Comment

Title *
Name *
Email
Comment *  
 

Tim Murphy

Tim is a Solutions Architect for PSC Group, LLC. He has been an IT consultant since 1999 specializing in Microsoft technologies. Along with running the Chicago Information Technology Architects Group and speaking on Microsoft and architecture topics he was also contributing author on "The Definitive Guide to the Microsoft Enterprise Library".



I review for the O'Reilly Blogger Review Program



Technorati Profile

www.flickr.com
Tag Cloud