XMLtype column update very slow
Any one has experience with XMLType column update? I have this piece of simple test code. The Xquery in the update slows down significantly as the record count increases. Is there alternative method to optimize this? Any help is greatly appreciated.
CREATE TABLE test_append_xml (tran_recon_xml XMLTYPE)
XMLTYPE COLUMN tran_recon_xml STORE AS BINARY XML ALLOW NONSCHEMA
/
CREATE TABLE test_append_timing (
rec_num NUMBER,
seconds NUMBER)
/
-- ----------------------------------------------------------------------------
-- Insert XML node (TrxnRec) 20,000 times to same XML parent (TrxnRecon) and time each iteration.
-- ----------------------------------------------------------------------------
DECLARE
ln_start NUMBER;
lv_temp VARCHAR2(4000);
BEGIN
INSERT INTO test_append_xml ( tran_recon_xml ) VALUES (