Re: Processing Large XML file ... recommendations

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 26 Mar 2005 08:15:05 -0600
Message-ID: <u4qeycnio.fsf@hotpop.com>

On Sat, 26 Mar 2005, bsc7080mqc_at_mylxhq.com wrote:
>
> I have a 17mb XML file that I need to process. Currently this
> file in on our database server and I am using BFILE operations to
> get the file loaded into a CLOB so that I can parse it. Ideally,
> it would be just a CLOB read from a table instead. Right now when
> I am using dbms_xmlparser, dbms_xmldom,
> dbms_xslprocessor.get_valueof routines the process is taking a
> very long time to parse and process. Looking for recommendations
> to speed the process up or multi-thread process techniques.

Do you have an xmlschema? Submit that to Oracle, then define you attribute as XMLTYPE of that schema definition.

Then use the xmlforest, xmlelement, ... functions.

-- 
Galen deForest Boyer

Received on Sat Mar 26 2005 - 08:15:05 CST