TIBCO Oracle Driver for inserting into XMLType column.
Article ID: KB0093496
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Description:
There may be performance issues while inserting a field type XMLType into a table.Note that inserting a CLOB type does not experience this issue.
Symptoms:
Inserting XMLType is much slower then inserting into a CLOB Type.
Cause:
When an XMLType instance is created, an XML syntax check is performed regardless of the storage architecture, to ensure that the XML document is well formed.
There may be performance issues while inserting a field type XMLType into a table.Note that inserting a CLOB type does not experience this issue.
Symptoms:
Inserting XMLType is much slower then inserting into a CLOB Type.
Cause:
When an XMLType instance is created, an XML syntax check is performed regardless of the storage architecture, to ensure that the XML document is well formed.
Issue/Introduction
TIBCO Oracle Driver for inserting into XMLType column.
Resolution
If you are going to store XML and plan never to use it, you may choose to use CLOB s instead of XMLType for storage due to the processing requirements of the well-formedness check. Additionally, if you can not be sure your documents are well formed, you may choose to store your documents as CLOB's. If you plan to use XML-related functionality with these documents, use XMLType.
The following is a quick overview of the types of applications that can benefit from using CLOB -based XMLType storage:
- Systems that require high-volume XML document ingest or that commonly require full document reads.
- Systems that are meant to be "unstructured" or that lack a DTD or XML schema to dictate the documents format.
- Systems in which the DTDs or XML schemas are likely to change frequently.
Additional Information
http://www.oracle.com/technetwork/documentation/o25xmlex-093100.html
Feedback
Yes
No
Powered by
