Question regarding - 'Parse XML Documents'

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

Question regarding - 'Parse XML Documents'

Postby oram » Thu Aug 23, 2012 6:53 pm

Hi,

This question is in regard to Tim's article 'Parse XML Documents' (http://www.oracle-base.com/articles/8i/ ... nts-8i.php).

We have developed the program in Oracle 8i using the method mentioned in the link however we are facing some performance issues when the records in the XML file increase in number.

In this article it has been mentioned that ' -- Form better performance multiple collections should be used to allow bulk binding using the FORALL construct but this would make the code too long-winded for this example.'. Can somebody provide me with an example where FORALL construct has been used and is giving a good performance.

Thanks in advance.

Regards,
M
oram
Member
 
Posts: 1
Joined: Thu Aug 23, 2012 6:47 pm

Re: Question regarding - 'Parse XML Documents'

Postby Tim... » Thu Aug 23, 2012 10:27 pm

Hi.

The bulk-bind will only improve the speed of the inserts, not the parsing of the document. You can see how bulk binds work in 8i here:

http://www.oracle-base.com/articles/8i/ ... nds-8i.php

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17936
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle SQL and PL/SQL Development

Who is online

Users browsing this forum: No registered users and 3 guests

cron